When I select a supplier on my form "frmCustomer" it shows in supplier lead time and updates tblProductsReceived. why wont unitPrice do the same..where am I going wrong?
Advanced Beginner
Windows 7 32bit 
Access 2010 32bit
When I select a supplier on my form "frmCustomer" it shows in supplier lead time and updates tblProductsReceived. why wont unitPrice do the same..where am I going wrong?
VIP
Windows Vista Access 2010 32bit
the query that does the update must include Price as well.
Advanced Beginner
Windows 7 32bit Access 2010 32bit
?..not following sorry. Query or the code and which query?
Advanced Beginner
Windows 7 32bit Access 2010 32bit
Tried the query linked to the form and changed the column no in the code but nothing seems to work.
Competent At Times
Windows 10 Access 2013 64bit
The column numbers are incorrect in the cboProduct_AfterUpdate code. Column numbers begin with 0, so unit price would be column 3.
Advanced Beginner
Windows 7 32bit Access 2010 32bit
I tried column (3) but it still didn't work correctly?
How to stop a form from auto updating table
Posting Permissions
Reply With Quote