Creating a search facility

[akhlaq768]

I need some assistance in creating a form that will allow a user to enter a staff id and the form should return the forename and surname of the staff member...

I have created a textbox that would allow the user to enter the staff id.
I have also created a query that will search the dataset and return the appropriate columns based on the criteria in the query.

But how do I link this all together. So i'm guessing I need a command button that will execute the query based on the entry in the text box? How do I do this?

thanks.

If you require any further information or clarification on anything, please shout.

Thanks in advance

 

[MStef]

Try to do it via FILTER BY FORM (ikon).

 

[akhlaq768]

Dont have that icon in 2002 version

 

[MStef]

Look at attachment (word, zip).
Access help about FILTER BY FORM.

 

[akhlaq768]

thanks for the attachment...

i think im nearly there... but i just need to the command button to populate the subform instead of running the query on a seperate page (see attached)

 

[MStef]

What are the PRIMARY KEYS (in your tables) ???
What are the FOREIGN KEYS ???
What is the RELATIONSHIPS ???
Where is the field STAF ID ???

 

[akhlaq768]

the primary key is patnt_refno
the relationship can be easily viewed from the query itself... it uses the patnt_refno to retrieve the staff if which is the Identifier field in the staff_id table

 

[akhlaq768]

any help guys..

just need a command button to search the dataset and return the value in the subform...

i have the query set up and running, just need to link it with the command button.