Command button to populate subform

[akhlaq768]

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.



Need help in creating a command button that will run my query based on the entry of the staff if and then populate the subform

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

Thanks in advance

[June7]

Don't need to 'run' the query, you should requery the subform. Code: Me.[Query1 subform].Requery

Could make the textbox a combobox and limit user entry to item from list. Also, instead of the criteria in query, can use the Master/Child links of subform container control. Set Master link to the combobox, Child link to Indentifier.

If you stick with the textbox and parameter in query, need wildcard with the LIKE operator: LIKE "*" & Forms!Form1!Search & "*"

[akhlaq768]

thanks... perfect