I am having a bit of a problem. I have two tables one called partnbr which has a part number and description field another table which has a detail with part number and qty etc... I have the part numbers linked on both tables with the part number on the part number table bieng primary key. What i want to do is have a combo box linked to the primary key and a text box linked to the description. Then a subform linked to the other table. I want the user to be able to type the part number in and get all the details of that part number which i had no problem doing. When i go to add a new record the combo box field doesn't go to null. What am I doing wrong?
Add a new record with a combo box
- Thread starter cliff7376
- Start date
