Help please with bloody text box

Hi,

Haven't used access for a long time and very rusty on things. Hope someone can help:

I have a table with store numbers and store names.

I want a form with a text box that when i enter the store number the appropriate store name appears in another text box.

It seems simple but im going around incircles.

Do i need a query. can i just use the table of info at this satge.

Che ers guys!

Jon

Create a query that joins the table you need for the form with the lookup table. Select the columns you need from both. Use the query as the RecordSource of the form. When you enter the store number in a field and tab out of it, all the related fields will automatically populate.