Text box query

[dunc]

This may be a simple thing to do but i am getting rather stuck by it.
What i wish to be able to do is run a query in access and place the result
in the relvent text box i have created on the form.

I am creating a student datatbase and what i wish to do is enter the student
ID into a text box, click the search button and the detail (name, Age etc) of
the student appear in the relevent place on the form.
i have created the query which works i just can not get it to populate the
result back into the form

 

[Jeanette Cunningham]

Hi dunc,
an easy way to do this is to use an unbound combo box.
User can select the name and the details can be made to fill in the relevant
field.
If you are new to this, you can use the combo box wizard to build the combo
and code.
Choose the option that allows you to find a record on your form based on the
value selected in the combo.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia