So simple I am embarrased

[quasar900]

I have been out of my access class for over a year and can't remember this simple thing.

I am in a form, based on a query. I want to automatically fill some fields on the form by simply typing in the ClientID. All my messing around with combo boxes and list boxes only brings all my information into the ClientID box. I think i remember it having to do with the row source and/or bound column. I know this is very simple - so hopefully the response will be simple too, so I can remember it.

 

[djreyrey]

hello

i am doing the same thing right now. what you can do is create a type of search in your form. what you get is, when you type in a client ID, or in my case a file #, the information for the client ID will populate the fields.

 

[wazz]

- the input textbox on your form should be unbound. i'll call it txtUserInput.
- in your query, set criteria for the ClientID to: Forms!frmYourForm!txtUserInput
- set the AfterUpdate event of txtUserInput to requery your form