How do I use a combo box to populate a textbox?

[DuWayne]

This is what I have. What I need is to populate in my
form PartNo with the PartNo from tblfbompart and
have it populate PartDesc from tblbompart and have it
place the information into tblMadeToStockParts PartNo,
& PartDesc. Alsochoose Model from tblModel using a
combo box and placing ModelID in tblMadeToStockParts.

Thanks

tblMadeToStockParts


MTSID
PartNo
PartDesc
Model
Memo
Attachment

tblfbompart
fbompartID
PartNo
PartDesc
Category

frmMadeToStockParts
MTSID
PartNo
PartDesc
Model
Memo
Attachment
fbompartID
ModelID

tblModel
ModelID
Model

[June7]

Should not save PartNo and PartDesc into tblMadeToStockParts, only fbompartID.

Bind Model combobox to the Model field in tblMadeToStockParts and the ModelID selected in combobox will save.

[alansidman]

In addition to June's comment, look at this for how to get the descriptive information into unbound text boxes on your form for display purposes only.

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

Alan