Please help!

[Christina]

I have a form, Service Cards, that displays information
for systems. I want to be able to type in the System Id
and have the appropriate record displayed. Since the form
will be taking the record from the query, Service Cards
Query, can I use a macro? I tried the GoTo command in the
Macro but it seems like it is used to go to controls
within the form you are looking at and not for taking
information from another form or query.

Any help that can be offered, would be greatly
appreciated. Thanks!!!

 

[fredg]

I have a form, Service Cards, that displays information
for systems. I want to be able to type in the System Id
and have the appropriate record displayed. Since the form
will be taking the record from the query, Service Cards
Query, can I use a macro? I tried the GoTo command in the
Macro but it seems like it is used to go to controls
within the form you are looking at and not for taking
information from another form or query.

Any help that can be offered, would be greatly
appreciated. Thanks!!!

Add a Combo Box to the Form's Header.
Use the Combo Wizard to set it up for you.
On the first page of questions, select the 3rd option,
something like 'find a record that matches... etc.'.
Continue with the wizard.
Leave the combo box unbound.
Set it's AutoExpand property to Yes.

When done enter the System ID you are looking for and click Enter.
That record will appear.