Problems with filtering form/subform

[natsirtm]

I have a form which contains a subform with tabs.

I've written a query which contains all the fields on both the main form and subform. I'm using this query as the recordsource for both the main form and subform.

I've been trying to apply a filter based on the PK ("ID") but am unable to get any data to populate either form. The forms are linked by master/child, I'm applying the filter in the main form.

Does anyone have a link or example of a suitable method to filter both forms based on the same value?

thanks
Tristan

 

[MarkK]

It doesn't make sense to me to use the same query to drive both a main form and a subform. This won't support a one to many relationship. Is this your intention, and if so, why bother with the subform?
Does the form populate correctly before you attempt to apply the filter?

 

[natsirtm]

There is no one to many relationship between the main form and subform.
The portion in the subform is fairly complex, with numerous fields. The main form just contains 6 or 7 basic fields.
I'm trying to open the form from a Click event on another form (launchpad) with the filter applied, so it actually doesn't populate anything but a blank form.

 

[MarkK]

Right. And what happens if you open the form without attempting to apply a filter? Does it still not populate?

 

[natsirtm]

I don't understand the question. The form is for an individual record so without a filter it will just open blank.

 

[natsirtm]

Ok, figured out a portion of my problem.

Due to the way the form needs to function, all the combo boxes had to be Unbound. I obviously needed to set a Control Source if I want to populate the boxes.

So I've fixed that, it will display the options selected in the various combo boxes.. Now to my new problem, no edits can be done unless those combo boxes are unbound.

Is there some way I can change the control source back to unbound without losing the values?