lookup field in table to populate another field in a different form

[4304]

HELP!!

I have a form that needs to lookup information in a table to fill one of the fields on my form. Anybody know how that works?

 

[PHV]

Replace the TextBox in your form by a ComboBox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[4304]

Thanks for the reply.

I changed the textbox to the combo box, however, I'm still getting the #Error message. Any other suggestions?

 

[PHV]

Why not follow the combo wizard ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[4304]

Thanks again for your help, but I don't think I was very clear when I asked my question. It's something like this:

"If the 'MR Suffix' in the 'PO Log Form' is the same as the 'MR Suffix' in the 'Material Category Codes and Lookup' table, then the 'Mat'l Cat Code' in 'PO Log Form' is the 'Material Category Code' that corresponds with the 'MR Suffix' record in 'Material Category and Lookup' table.

I hope I didn't confuse you as much as I have confused myself.

 

[PHV]

Well, please read carefully the second FAQ in my sig

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[4304]

Okay, thanks anyway!!