Hello all, I have a question regarding forms and lookup values on controls on the form. This is what I would like to have: a form with a text box where I type in a order number. I would like to click a command button where based upon the order number typed into the text box a query would run and populate two other text boxes such as first name and last name.
So if there was an order in my table for Jeff Smith and that order number was 101. I would like to type in 101 in the order number text box, then click a button called- 'retrieve information' and that would populate the first name text box with 'Jeff' and the last name text box with 'Smith'.
I'm having a heck of a time trying to figure this out, I don't want to use a drop down or combo box for the order number, I need them all to be text boxes.
Also, once this information is retrieved on the form I would like to have an 'add' button that when clicked would take all the information on the form and append it to a table.
If anyone can provide precise information on this I would be very grateful.
Thank you.
So if there was an order in my table for Jeff Smith and that order number was 101. I would like to type in 101 in the order number text box, then click a button called- 'retrieve information' and that would populate the first name text box with 'Jeff' and the last name text box with 'Smith'.
I'm having a heck of a time trying to figure this out, I don't want to use a drop down or combo box for the order number, I need them all to be text boxes.
Also, once this information is retrieved on the form I would like to have an 'add' button that when clicked would take all the information on the form and append it to a table.
If anyone can provide precise information on this I would be very grateful.
Thank you.
