asked on

Find specific record on form with dataentry set to yes

Hi and thanks in advance for any help.

Can someone please help me with an example code on how to find a specific record in a form with data Entry set to yes.

I have one form called customer details and another form called 0_01mm they both have textboxes called ID that are numbers.

Im using access 2003.

Thanks Rob

peter57r

Your question does not make sense to me.
If you have DataEntry set to Yes then the form will not display any records, only a new record template ready for data entry.

Declan Basile

If ID is the name of an unbound textbox, you can put this code in the afterupdate of the textbox
Me.RecordsetClone.FindFirst "[ID] = " & Me!ID
Me.Bookmark = Me.RecordsetClone.Bookmark
That will set focus to the record with that ID.

I don't completely understand what you want to do, but if you have multiple records in the "customer details" form for the specified ID you can open the form with a filter set.

robultra17

ASKER

Hi

Yes ive got several records in customer details i want to goto a specific record using the id which is an autonumber, from a form called search.

ASKER CERTIFIED SOLUTION

Declan Basile

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

robultra17

ASKER

Thanks thats just what i want

I'll test the code and let you know

Thank you

robultra17

ASKER

Works great

Thanks