Form combobox won't bring up values

[sevanty7]

Hello,

I currently have a form (EditRecord) with a combobox that when a record is selected, it will fill in values in textboxes also on the same form.
It works great and does exactly what I need it to do when I open the form directly from the navigation pane.

However because the final product will have the navigation pane locked I have created a form (Goto) in which users can choose between the different forms I have created.
When going from the (Goto) form to the (EditRecord) form the combobox still has the same values to chosse from but it does not fill in the textboxes on the form like it would if I opened it from the navigation pane.
I have run into and error like this before but I was using the predesigned Navigation Form already in Access. Trying to avoid the same issue I created the GoTo form from scratch and the buttons that take you from one form to another are only simple macros




Its a little blurry but whats above is just the OpenForm, with the EditRecord form choosen to open upon clicking the button.

Thank you for any help you can provide.

[orange]

What exactly is form (Goto) ?

[sevanty7]

Sorry, the Goto form is simply a form with several buttons on it that the user needs to make it easier to navigate. for example:
the user would eneter the database, the would either be staff or a customer.
If staff they would choose staff --> enter the correct password on the password form ---> goto form (choose edit record) ----> Edit record form

[rzw0wr]

Try changing the Data Mode to Edit.

As the Macros sets now you can only add to the underlying dataset.


Dale

[sevanty7]

Okay i changed the data mode on the button to edit, it was on add but it still will not bring up entries intot the textboxes

[rzw0wr]

Try;
DoCmd.OpenForm "frmEditRecord", acNormal, , , acFormEdit, acWindowNormal

Change the embedded macro to event procedure for the On Click event and paste this there.

Dale

[sevanty7]

That worked perfectly, thank you so much, made my friday

[rzw0wr]

You are most welcome.
Glad we could help.


Dale