This is going to be extremely frustrating for all parties involved, because there's no error message - or any hint as to what's going on.
I have a form, frmSub, that has comboboxs linked to fields in two different tables, Products and PurchaseDetails. All the comboboxes linked to Products are working fine, but when I try and enter anything into the ones connected to PurchaseDetails all I get is a 'beep' and nothing happens.
I've definitely included all the appropriate fields in the record source of the form. I have no idea what else to try.
Here's the code for the record source query of the form. PurchaseDetail.Price and PurchaseDetail.Quantity are the fields not working:
SELECT Products.Product, Products.Size, Products.Brand, Products.UnitOfMeasure, Products.ProductID, PurchaseDetail.Price, PurchaseDetail.Quantity
FROM Products INNER JOIN PurchaseDetail ON Products.ProductID = PurchaseDetail.ProductID;