Display Record Updates After Entering Data

[forrest33]

I have an input form. It has, among ohter fields, a Company Name (drop down lookup in a Manufacturers table) and a Memo field. I can enter nice and easy info and it does go into my backend table, no problem. However, I want the form to display the newly entered info for every Company Name that I pick from the drop down (based, again, on lookup from a Manufacturers table).
I cannot figure it out and I am pressed for time, which does not make it easier. Thanks.

 

[gwinn7]

You can reset the recordsource of your form to reflect the data you selected in the combo box. Customize your SQL statement in your after_update event of the combo box. Or, you can reset the record source to different queries.

Gary
gwinn7