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.
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.