Question about finding specific record on a Form linked to a table
in [Forms]
|
From: Steve Haack on 10 Dec 2009 22:13 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
From: KARL DEWEY on 11 Dec 2009 16:04 Check out macro FindRecord action. -- Build a little, test a little. "Steve Haack" wrote: > 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
|
Pages: 1 Prev: DoCmd.ApplyFilter generates Parameter prompt Next: Using the primary key in an autonumber |