form displays recordset incorrectly

using ms access 2000, I have a form(VB) that when it displays a record using the find/replace function, it displays properly however, the record locator at the bottom of the form stays on the previous record messing up any updates.

I'm attaching the form.

Any help is greatly appreciated!!

JOE

thejoemeister,

How are you using the "find/replace function"?


What are you trying to achieve? If you want to change iformation in records I would use an udate query.


Also there is not attachment to your post.

Regards,

My boss has a form that displays table data. It has a search button that when clicked, it calls the MS Access Find/Replace tool. When a search is performed and a record is displayed, it does not change the record locator so when edits are performed, the changes are applied to the "previous" record and not the current one. I tried uploading the form, but I don't see it anywhere here.

In the meantime I will study up on the update query.

JOE

Joe,

To post the database firstly zip it then attach it.

Let me see you have a form with controls etc and you want to FIND a certain record for say a certain customer. Am I on the right track? If so then you need to use a combo box to look up the record and display it in the form. An update query is to change data in the underlying table.

If this is what you want to do then reply and I will send you a sample db. My way only works if you want to look up set fields.

Anyway reply and I will take it from there.

Regards,

The db owner created a table for everything that the data entry clerks fill out. Essentially, everyone works out of the same table.

The owner had someone create a form that created different levels of user/groups so that access to the db was regulated. In comes me, the joemeister, and since I know what MS Access is and I have played with it before, I've been tasked with fixing this mess.

The problem is thus:
With the one "Master sales" form, depending on the user, certain fields will be accessible. The way it is supposed to work, when a search is performed an lets say you were at record #5, it "displays" the found record, let's say #10, however, when you click on "Notes" in order to make some notation, the record is #5, the one previous to the search. It's like the record curser is not following properly.

Been working on this for over 3 weeks, so any help is extremely appreciated. The database won't compact to less than 4mb so I'm sending you the "master sales" form. If you need the whole database, please provide an email address that will accept a 4mb file.

Again, many, many thanks!

JOE

Joe,

No attachment.


Regards,

Grrr, not sure why the file is not uploading. Trying again.

Thanks for your patience.

JOE

I have exactly the same problem here.

I use
If Not IsNull(Me.OpenArgs) Then
Me.RecordsetClone.FindFirst Me.OpenArgs
If Not Me.RecordsetClone.NoMatch Then Me.Bookmark = Me.RecordsetClone.Bookmark
End If

to go to a specific record. I get to see the specific
record. However, when I update the information in
the record, the update info gets stored in the
previous record.

I have this problem both on Access XP and Access 2000,
using SQL Server 2000 with latest service pack.

I tried installing the latest MDAC and the latest JET Engine
service pack, but the problem remains there.

After more extensive research I have now found the
following:

This does not work. The form jumps to the correct
record, but does not store any results:
Private Sub Form_Open(Cancel as integer)
me.recordset.findfirst me.openargs
End Sub


This jumps to the correct record, but does not store
any changes:
Private Sub Form_Open(Cancel as integer)
me.requery
me.recordset.findfirst me.openargs
End Sub

This does not jump to the correct record (duh):
Private Sub Form_Open(Cancel as integer)
me.recordset.findfirst me.openargs
me.requery
End Sub

HOWEVER, and this is strange, the following has
solved *all* of our problems:
Private Sub Form_Open(Cancel as integer)
me.recordset.findfirst me.openargs
me.requery
me.recordset.findfirst me.openargs
End Sub

It jumps to the correct record AND it stores our
changes in the SQL server in the proper record.

Oh, and in case people are wondering: the problem
can be reproduced for several tables/forms, but not
for everything. I haven't figured out what causes
the problem.

Thank you, but I'm not sure where to place this code in the form. Should I bind it to the search button or an additional button? I tried the search button, but to no avail. Thanks!

JOE