create message box to find a record

[hullstorage]

i am trying to create a message box based on something like a query

the query contains a postcode field

so basically when i create a search button on click event

message box asking user to input postcode to find
then this will open the query form based on results entered by the user

any help

thanks in advance

simon

 

[neileg]

Create a query that retrieves all the valid post codes from your data and no other fields. Create a form. Add a combo box to the form that uses the postcode query as a datasource. Create your query form and in the query that underlies this form, use the combo box as a criterion in your postcode column in the query using the following syntax:
Forms!MyFormName!MyComboBoxName