Load other form fields from drop-down box selection 1

[tviman]

Hi all,

I've created an "Edit" form to edit work order records in my database. When I select the desired wo number from a combo box, the rest of the fields on the form don't get populated with data. I've tried both bound and unbound combo boxes but no joy. What do I need to do to the combo box (presumably the AfterUpdate event) to populate the rest of the fields?

Thanks for your continued help!

 

[dhookom]

How about some tables and fields, combo box Row Source, form Record Source fields?

If you want to store any value in a table, it typically involves a bound control.

"populate the rest of the fields" generally means your table structure isn't normalized. Can you provide some facts that suggest I'm wrong?

Duane
Hook'D on Access
MS Access MVP

 

[tviman]

Hi dhookom...

The table is, in fact, normalized. The form record source is the table (there's only one table). The combo box is the wo_nbr field and this field is the primary key. All I want to do is select a wo_nbr from the existing table and populate the edit form with the fields from the same record so I can edit the existing data via the "edit" form. I've done this before but it's been a few years since I dabbled in Access and I've lost my way.

 

[dhookom]

There is a combo box control wizard that does this for you. The "find wo_nbr" combo box is not bound.

Duane
Hook'D on Access
MS Access MVP

 

[tviman]

dhookom,

Ever had a day when you've tried everything but nothing worked? Then you had a friend or collegue do the EXACT SAME THING you did and it worked? You get the picture....

Thanks for your kind assistance!