Question about finding specific record on a Form linked to a table

S

Steve Haack

I have a Form that is linked to a table. It has been used for a while for
both viewing records and for updating data.

I have added a combo box to the form, and set it RowSource to a query that
finds a smaller set of records from table that the Form is based on.

When the Form opens, it always goes to the 1 record that was created in the
table.

What I would like to do, is have it open to the 1st record in the ComboBox.

In the Form_Load and Form_Open, I have tried setting the Combo to it's first
item, which works, and then calling Combo_AfterUpdate to execute the loookup
for the record that has been selected. When I call AfterUpdate it gives me an
error that "the expression requires the control to be in the active window".

Where can I place this to make the form open to the 1st record in the combo?

Thanks,
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
How to set different combo box values for new record? 6
Combo box not finding record... sometimes 3
Startform to open specific record 6
lookup question 1
Combo box to limit selection based on current record in form 1
Lookup current record with ComboBox, any changes create new record 3
Open form at first Alpha not first record number key 5

Top