Macro button to find a record and edit

[red6000]

Hi I have a table of data (QA)

I then have a form that was auto created when the table was created for
entering/editing data (INPUTFORM)

To help the user, I have a macro button that will launch the form at the
'Add record' level.

What I would like to do is have a macro button where the user can eneter 1
bit of data that searchs column (WFI) and then opens the form at that
relevant record.

I'm struggling with this, any help appreciated.

Thanks.

 

[tina]

in the OpenForm action of your macro, you can use the WHERE CONDITION
argument to select the specific record you want returned in the form as it
opens. read up on the OpenForm action and its' arguments in Access Help, to
understand how it works. note that using this method will return only the
record(s) that meet the condition, not all of the records in the form's
underlying table or query.

hth