see the below screen shot.
i have a subform with combobox.
when i selecting item from combobox it adding product to its respective table.
hwo to prevent this behavior?
Download my project
see the below screen shot.
i have a subform with combobox.
when i selecting item from combobox it adding product to its respective table.
hwo to prevent this behavior?
Download my project
Sounds like the combo is bound to the product table instead of the orders table.
The subform should be bound to OrderDetails table. Do not include Products table in the RecordSource.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
If i bound to OrderDetail then how i can populate all the product in sub form combo box?
It's row source is the products table, not its control source.
I have set Control Source property of Combobox to fkProductID(Primary Key) instead of Discription and Problem has been solved.
Thank you so much @pbaldy for your humble suggestions.