You need to look at the row source of the combo and make sure any references to controls on it are done at the subform level:
http://access.mvps.org/access/forms/frm0031.htm
Cheers,
Here is my row source I a novice at this
SELECT [Products].[Part Number], [Products].[ProductName] FROM [Products];
Can you post a copy of the db
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Am I missing something here?
Your first form uses Product Name and populates Unit Price and possibly Extended price using the Quantity?
The second is using Part Number and does nothing.?
The query for both would be different I would have thought unless you move the bound column?, plus we have no idea as to what the source is for those other controls on the second form.?