Unanswered: Trying to Find Record - Combo Box Not Working
I have a form - Invoice form and when a user clicks the add button, it adds a new record, no problem there but now the user wants to have a combo box that pulls from the customer table, select the customer by ID and Name and that fills in the customer information on the Invoice Form..
I can't get it to work, the code I have is below and it will only find the First Invoice ID, does not do what I want...
Not really enough information here to give you a definit answer to your problem but perhaps guide you towards the solution.
First you will need to set up the combobox located within the Invoice form so that is will display the required data (Customer ID and Customer Name). This is relatively easy to do with the query builder.
Now...In the OnClick event of the ComboBox (which, by the way, is fired when a user selects the customer name) you need to enter code so as to fill in the pertinent areas of your Invoice. Perhaps something like: