Search results

I figured out the problem.. I needed a Me.Undo before setting my Me.Bookmark to the record.

Any help available on this yet? I'm desperantly seeking answers...

Just in case it matters, here are my form properties for the 'Data' tab.

I am very close to getting this. It's finding the Record but for some reason giving me the following error: "Microsoft Access Run-time Error '2105': You can't go to the specified record. You may be at the end of a recordset." Here is my code: Dim rs As Object Dim varBookmark As...

Access 97 is screwing me up I think... but this is what it has to be done it. I tried your code and it wouldn't accept rs = Recordset.Clone but it would accept rs = RecordsetClone so I used that. Then it wouldn't accept the FindFirst statement, but it will accept just a plain Find. I tried...

On entry to my form it opens a new record for the user to add. At the top of this form I have two fields that are entered first. A Store # and a Date. I have an index setup with those 2 fields that does not allow duplicates. This is what I would like to do. They enter their store number and...

For option 1, go to design mode on the form. Open up the form properties and click on the 'Event' tab, scroll down to 'On Load' and build a procedure in the Code Builder. This is the code you need to go to a new record on form open. Private Sub Form_Load() DoCmd.GoToRecord acDataForm...