FindRecord

[Werx]

Hello

Say I have a form which Contains an autonumber used as the constant
RecordID, (when I delete records it rearranges the Record numbers in the Nav
Bar). And on this form i want a button that will recall a requested record
and all its values in the current form (which was initially used to create
the record) by finding a user entered RecordID. By user entered I mean when
I press the find button the form askes me to enter a RecordID.

How would I go about this?

I have tried parameter like
= Form![Records]![RecordID]
in a findrecord macro but keep getting errors

Daniel

 

[tina]

in form design, the Tool Box wizard will build a combo box to "find a record
on the current form", including writing the code for you. you say that the
RecordID (primary key field, i presume?) is an Autonumber field. under
normal circumstances the user never needs to see an autonumber; suggest you
may want to use another field in the table to identify and find the record
you want.

hth