I think I figured it out I'll let you know. I think it was the record source.
Thanks for the help.
This is what I found and did....
http://support.microsoft.com/kb/319482/en-us
It was the record source setting. I created a new table according to the directions on the kb in the link. Then...
I don't think that is exactly what I am looking for. It only gives one value in the field. I want to be able to pull down, click on one item and have it fill in values on my form for 3 other items.
I have been trying for a few days to make this work and I can't figure it out. I'm sure it is probably something real simple.
I want to be able to select a value from a combo box and then have the other 3 fields fill in based on the value I selected in the combo box.
I have looked at the...