Populate form with cbobox (1 Viewer)

JPR

Registered User.
Local time
Today, 15:42
Joined
Jan 23, 2009
Messages
192
Hello friends. I would appreciate any help with this small problem.

I have designed a form with a records source to table "tblCustomers".
This table has fields like, ID, LName, FName, DOB, etc.

When I open the form, it automatically goes to a new record:

DoCmd.OpenForm "frmCustomers"
DoCmd.GoToRecord , , acNewRec

On the same form, I have added a combo box with the row source based on a build in query (based on tblCustomers) as I would also like to give users the option to select a give record on the On Change event.

On the form I have places the field ID which is obviously included in the query but when I change the selection, I don't get the selected records.

Thank you for any help.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:42
Joined
May 7, 2009
Messages
19,169
if you follow the "wizzard" when you add the combo, it will give you an option to "Find a record on your form (the 3 option).
i suggest remove the combo and drag a new combo and follow the wizzard.
 

JPR

Registered User.
Local time
Today, 15:42
Joined
Jan 23, 2009
Messages
192
Thank you
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:42
Joined
May 7, 2009
Messages
19,169
when you Add new record (customers), you also need to Requery the combobox.
 

Users who are viewing this thread

Top Bottom