Populating a field

[manicminer]

A completly newbie question, I know.

Say I have a table "product" with fields "serial" and "company"
I have a an unbound form, where in one listbox I can choose from all the "serial" values.


Now, after i choose the "serial" from the listbox, I would like to display the value "company" in a textbox (from the currently selected record).

Should be trivial, but it eludes me....

[pbaldy]

Does this help?

BaldyWeb - Autofill

[mholland999]

Use the Dlookup function

dlookup("[Company]","Product","[serial]='" & <me.yourformfieldname.value & "'")

you can assign the value of an unbound control to a the dlookup function. you might have to write a bit of code on the afterupdate event or the onchange event to update your calculation

Sub onchange()
me.yourformfieldname.requery
End sub

[pbaldy]

It would work, but why make a second trip to the data when the listbox already has it?

[manicminer]

Thanks everybody, but I cant somehow figure it out. Maybe I didn't specify the problem correctly.
So.... the table stands as before. "Serial" is the primary key btw.
The form contains only two fields. A combo box and a text field.
In the Combo box, I can choose from all the "serial" values from the table.
After the "serial" is selected, I need the textbox to dispay the value of the company field associated with it.

Unfortunately any varions in the "after update" property of the combo box doesnt yield right results :-(

[manicminer]

Figured it out, finally. Thanks to kicking me in the right direction ! :-))))

[pbaldy]

Glad you got it sorted out. I was sound asleep!

[mholland999]

manicminer you should post your solution for other readers.