how do i create a jump to combo box that when a customer is selected it will display all the info in the fields in a form.

I'm not sure what you mean.
You want to set the focus to a combo box?
You use vba. Open the Module for the Form:

me.ComboBoxName.SetFocus

Database Agreements

I think he means to select a customer on a combo box and to have all the fields
on the form updated to that customer.
Rgds Penta

You can use the wizard (toolbox) in Access to create a combo box that has the customer Primary Key in it as the first field, and then go through the wizard to select a record on the Form depending on that selection of the Wizard.

Hope that is what you need,




Database Agreements

I dont think Mjuliao has problems with creating a combo box. He wants to have
the text boxes on the form updated when he select a customer on the combo box.
Hope he help us help him.
Rgds P

Well, perhaps I don't understand what he wants.
However, if what he wants is what you are saying,
1. Have a combo box on the Form which when updated selects all the information about a customer.
This wizard creates VBA Code which would use the RecordSet Clone property to find the customer in the QBF and then bring the current record of the Form to the customer.




Database Agreements

hi,

well, i did the cbo using the wizard and it does what i want, the only problem is that when i change the record using the arrows on the botton part it doesn't changes the info on the cbo.

In the Form_Current Event of the Form
Use something like this

me.cboName = me.PrimaryFieldName

I am assuming the Primary Key Fields exist in both the ComboBox and on the Form.

Database Agreements