Display info from another table on current form

[abernut]

I have created the following database


I have the following form that allows users to enter data into the MoldReq Table


I need to create a form for the Mold Log. The user will select a Work Order, which is stored in the MoldReq table. Once this is selected I need the Mold and Part Name Fields to be auto filled based on the Mold selected. These values are also in the MoldReq table.
It will look something like this:


Thanks,
Mike



EDIT>>>
I just relized that the ParName is not stored in the MoldReq table. That information is stored in the Mold Table.
On the Mold Req form, when they click the drop down button to select the mold, I have three columns that display the Mold Number, Part Name, and Part Number.

Do I need to add a Part Name field to the MoldReq table

[abernut]

I forgot to mention.
The Mold and Part Name are just there to assist the user. They are not being written back to the MoldLog table

[pbaldy]

Does this work for you?

http://www.baldyweb.com/Autofill.htm

[abernut]

I have tried that method by creating an On Change Event on the WorkOrder field but have not been able to get it to work.

[abernut]

I think I have almost got it.
Instead of using an On Change Event. I created two text boxes and set the control source =cboWorkOrder.Column(1) and =cboWorkOrder.Column(2).
The boxes change like they are supposed to but now I get "The records cannot be deleted or changed because 'MoldLog' includes related records."

[pbaldy]

Text boxes like that should have no effect on deleting records, as they aren't bound anyway. I suspect you already had that issue. Sounds like referential integrity is set up, and protecting you from orphaned records.

[abernut]

Text boxes like that should have no effect on deleting records, as they aren't bound anyway. I suspect you already had that issue. Sounds like referential integrity is set up, and protecting you from orphaned records.

You are correct.
I had to edit one of the relationships on another table.
It now works as it is supposed to.

Can I ask an unrelated question here about the same db or should I start a new post?

Thanks,
mike

[pbaldy]

If it's unrelated it should be a new thread. It makes things easier on people searching for answers later.