Loading records to bound textboxes based off of combobox selection

[JasonMann1979]

This seems so simple, but I cannot seem to get it to work. I have a form linked to a table. If the user chooses to use a combo box to select an ID I want the rest of the bound text boxes to fill with data from that particular record.



I tired to add a combobox using the wizard, but only when I choose the ID in the combobox, none of the other records push to the text boxes.



Thanks for the help guys!

Jason

[June7]

You want to filter a form based on criteria entered into UNBOUND combobox?

A parameterized query is one approach. Review: http://www.datapigtechnologies.com/f...tomfilter.html

The wizard probably generated an embedded macro instead. Examine the macro code.

I never use the wizards because they do things I don't like and they inhibit understanding code.

[JasonMann1979]

Got it! Thanks June7. On top of the info in the data, I had to set "Data Entry" from the data tab to No. It looks like I'll need to make copy of this form and use one for data entry and one to review the data.

[June7]

"Data Entry" won't allow display of existing records.

Use one form. Just change the mode when it opens. This is an argument of OpenForm method.