Linking Child and Master Forms and Being Able to See All Records

[McArthurGDM]

Hi,



I am linking two forms.

In one form, I have a Query built into it - this is the subform (Child Form) and it shows all records pertaining to a query. I also have a Master Form. This form should just show one record at a time as they are listed within the query.

I want the Master form to show one record at a time so that I can make edits within the query and I want the subform to show all the relevant records within the query (preferably scrolling along as you move through the records in the Master form).

Whenever I link the forms, however, I can only see 1 record at a time - at best - within the query. This is probably because I am only showing 1 particular record within the Master form.

I don't know how to fix this issue - any advice?

[June7]

That would be expected behavior if the forms are bound to same data and you set the master/child links. This is what Split form was designed to accomplish. Replicating a split form means not setting the master/child links and using code to move to corresponding record in subform (or vice versa if record selection is done in subform).

Consider the split form.