This is so simple. Why can't I get it????

[Noreene Patrick]

I have a form that I key in the truck Id and it pulls in serial number from another table. But sometimes I only have the serial number and I need the truck Id...so, I put a command button on my form named Find.

When I click the button, I want it to give me an input box that asks "Please enter serial number." (I have that). But I dont know how to tell it to go to the table, look in column "serial number" and pull in the truck id.

Can you help?

Thanks so much,
Noreene

 

[AlienRay]

Don't bother with the find button. Instead, just put in a combo-box linked to your Truck Information table. Assign it two columns: serial number and truck ID. When the user starts typing the serial number, the combo box will autofill the rest of the entry. For your On Exit event on the combo box, put in something like:

Me![TargetFieldName] = Me![ComboBoxName].Column(1)

And your target field will automatically get updated with the Truck ID.

 

[Noreene Patrick]

Thank you for responding so quickly...It worked!!

Noreene