This is probably a very simple problem, but I've run into a brick wall here and haven't been able to find the solution anywhere... I probably am just searching on the wrong keywords.
I have a form that has the user choose a customer ID from a combo box, which then populates another combo box of invoice numbers, both from the same table. I want the users to be able to choose a customer ID, look through available invoices for that customer, pick one and then click a button to run a report on that customer/invoice combo. This part works without a flaw.
The part that is troublesome is that the form always updates the first record by changing the CustomerID and InvoiceNo to whatever the user chooses when running their report.
Is there a way to use a form for this purpose without having the user's choices actually update the table data?
I have a form that has the user choose a customer ID from a combo box, which then populates another combo box of invoice numbers, both from the same table. I want the users to be able to choose a customer ID, look through available invoices for that customer, pick one and then click a button to run a report on that customer/invoice combo. This part works without a flaw.
The part that is troublesome is that the form always updates the first record by changing the CustomerID and InvoiceNo to whatever the user chooses when running their report.
Is there a way to use a form for this purpose without having the user's choices actually update the table data?