Lookups - Type a value in 1 field and another field updates

[fasterthanyours]

So I used to know how to do this, but I haven't written an access database in about 10 years. I kill at Excel, but I new some help.



So I have this form RMA which puts data in the RMA Table.

I have a Parts_List table that contains 2 fields Part_Number and Description.

When someone times the Part_Number in the Part_Number field on the RMA form, I'd like the description to auto populate so they don't have to type it.

Also I would like the Part_Number field to use the Part_Number's from the Parts_List table, so they get the list of part numbers as they begin typing in a partial on the part number.

Uh crap I can't upload the accdb file. Someone tell the admin to add that to the list of acceptable files.

Oh well...Any help is better than where I'm at now.

[TheShabz]

in the OnChange or AfterUpdate (or whatever you choose) run a Dlookup(field,table,criteria = me.txtpartNo) then display that value in the description textbox.

[fasterthanyours]

Thanks But now I'm completely lost. I've attached the mdb version of the database. Could you please have look.

I've seriously been out of Databases for 10 years and it's all foreign at this point.

[TheShabz]

i dont have access to Access right now. I'd have to go till next week to look at it. What I mentioned would be written in VBA and run.

[fasterthanyours]

Ok, I'll take another go at it. Thanks.