Display results of a query on the main form

[wquinn]

I have a database for a doctors office. I have a form call patient info with a combo box and several fields. I want to be able to select a patient id from the combobox and then click a button to run a query to retrieve the data from the patient id table and display the results in the main form where the combobox is located. I do not want to use a subform, only the main form. Can anybody help me achieve this?



Thanks.

[June7]

Is the main form bound to table?
Maybe this is what you are looking for http://datapigtechnologies.com/flash...tomfilter.html

[Missinglinq]

This is essentially the same as the demo June7 gave you a link to, but why not simply let Access do all the work? You may have done some of this already.

• Create a Form using your Table/Query as the Record Source.
• Go to the Field List and drag the Fields you want retrieved onto the Form
• Place a Combobox on the Form.

When the Combobox Wizard comes up:

• Select "Find a record on my form based on the value I've selected..."
• Click on Next
• Select the appropriate identifying field to appear in the Combobox
• Click on Next
• Size the Combobox column
• Click on Next
• Name the Combobox
• Click on Finish

Now the user can use the dropdown arrow of the Combobox to retrieve the data or simply start typing the identifying data in and the Combobox will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

Linq ;0)>