I have a main form with two subforms (both in datasheet view), neither
of which are linked to the main form. The main form is based on a
query that uses the bound column of a combobox on the main form as the
criteria for the query. The combobox is based on a query that
retrieves the name and record id of the customers. In the afterUpdate
event of the combobox on the main form and both subforms are
requeried. The first subform is based on a query that retrieves
records based on the bound column of the combobox on the main form.
The OnClick event of the first subform forces a requery of the second
subform. The second subform is based on a query that uses the record
selected in the first subform to show data for the record selected in
the first subform. I have an edit button on the main form that opens
another form that presents the data in both subforms for editing.
This edit form is based on a query that retrieves the data based on
the record selected in the firsr subform. I use queries everywhere to
keep down the amount of data that is being pulled across the network
as this is a multiuser app. When I save the changes on the edit form
I requery both subforms on the main form to reflect the changes made
on the edit form. My problem is I need to have the first subform be
requeried then have the same record selected that was originally
selected when the user click on the edit button to open the edit
form. I can then requery the second subform to have it show the
records for the item selected in the first subform. I have tried
using bookmark and gotorecord but I lost here so how can I do this???
I hope my explanation is clear enough...
TD
