Parameter Query Using a Text Box instead of the generic Access Prompt? (1 Viewer)

Hi there,

I was wondering if its possible to use a text box on a form to do a parameter query instead of access prompting the user?

I would the User to be able to enter a phone number into the top of an invoicing form and for all the client information to appear below it. Because I am using several tables I seem to have to use subforms, 1 for agency info look up (telephone problem), 1 for populating a hotel list, 1 for populating a car dealer list, and one for populating the airport codes section.

So I would prefer if the query would just use one of the textboxes I created and used the value inside it to look up the relevant Agency information. I'm worried I thought too much was possible when it isnt..

Please let me know.

Sincerely
Jordan

Assuming the text box is on the main form, replace the Access prompt with:-

Forms![FormName]![TextBoxName]