I am trying to design a form, so that when I use the drop down menu to choose a customer, it automatically fills in the address, city, etc. I am trying to do it like its done in the example db. (The Northwind example, under the orders form)

Create your combo box using the Wizard. On the first screen select tje third item, "Find a record....". Finish the Wizard. Now when you make a selection from the combo box that record will be displayed on your form.

I tried doing the combo box, and third entry but then I had to click the down arrow to put the down arrow in the field how do I get around that?

Are you looking to FIND a record or create a new one? Jack's option will have you FIND a record that already exists. (Put it in your piggy bank for later)

Your problem seems to lead me to the idea that you are trying to create a new record...You want to choose the customer from the combo and then have the other information filled in for you......

Is that the case?

[This message has been edited by jwindon (edited 11-09-2001).]

To input data from a record automatically by entering an ID of some sort, I think Im making progress, just have to refine it a bit by taking out the repeated entries

If you want to fill fields in a form from fields in your Combo box then here is what to do... I will assume that your combo box has fields in this order: ID, LastName, FirstName, Address....etc.

In the After Update event of the combo box put code similar to this:

Me.LastNameFieldOnForm = Me.ComboboxName.Column(1)
Me.FirstNameFieldOnForm = Me.ComboboxName.Column(2)
Me.AddressFieldOnForm = Me.ComboboxName.Column(3)

Change the names above to those on your form and in your combo box. Selecting a name from the combo box and hitting the enter key will now fill in the fields in your form. I hope I got it right this time...



[This message has been edited by Jack Cowley (edited 11-09-2001).]