DLookUp Alternative in Form Fields - Value needs to be stored in a table.

[accessgm]

I have a main table that contains several text fields where the Display Controls are combo boxes. The selection choices for the combo boxes are from a second table. This main table is the record source for a form. As shown in the image below, when P5 is selected per the drop down, I would like P5Price and P5Description to auto populate with their corresponding values from the second table. I can accomplish this with DLookUp’s as seen in the example, but I need the results stored in the main table for the unique record that is being viewed in the form. Thanks in advance! GM

[Minty]

In the combo add the two fields you need as hidden columns to the combo row source.

In the after update event of the combo set the other fields to the hidden values using something like (assuming your combo is called cmbP5, and the bound column is the first column)

Me.P5Price = Me.cmbP5.Column(1)
Me.P5Description = Me.cmbP5.Column(2)

Combo column numbering starts at 0 - so the second column is referenced as Column(1) etc...

[CJ_London]

in your combo for P5, also bring through price and description. Assuming you are bringing through an ID, you will have 4 columns

ID, P5name, Price, Description

set column widths to

0,5,0,0

in the combo afterupdate event put

me.p5price=p5.column(2)
me.p5description=p5.column(3)

not clear on your naming convention so change names to suit

[accessgm]

Thank you both for the solutions! Followed as suggested and working as needed!