hello you guys thanks a lot for your help in the past. I found a old back up copy of the DB and it is a MDB file. So I wanted to see if you could still help me with this issues. I have a form with a table in it that I would like to do an auto fill. The two fields I'm working with is Part number and ECPS Cost. The Part number field is a list box field that show 3 fields(part number, description, and part cost) the part number is the Primary key. I want the ECPS COST field to auto fill with the part cost when you select the part number. thanks in advance for you help with this.
I'll take a stab at it...
Is all of the pricing data in the table?
If so, let's call the ECPS COST field [Price] and we'll call the list box [PartNumber].
[Price]should have a Row Source something like: SELECT PartsQuery.Price, PartsQuery.PartNumber FROM PartsQuery WHERE (((PartsQuery.PartNumber)=[PartNumber]))
The second part is going to the [PartNumber] box and changing the AfterUpdate (code) and put: Me.Price.Requery. That way, once you click something in the list, it will refresh the [Price] field.
That's how I would do it and have done it in the past. Someone may have a better suggestion..