Form -> Combo to a SubForm

[Dorian C. Chalom]

OK try three...

Lets see if I can explain this correctly...
I have a form based on a table.
And I have a Combo Box based on a Query based on a Table filtered on the key
value from the Form table.

And now I need to base a Subform on a table filtering the records on the key
value from the main form and the value selected by the combo box. I need to
be able to add records to this subform table.

Does this make sense? Can someone help?
I do not think I can simlify it anymore, but if I can...

 

[John W. Vinson]

OK try three...

Lets see if I can explain this correctly...
I have a form based on a table.
And I have a Combo Box based on a Query based on a Table filtered on the key
value from the Form table.

Care to post the query in SQL view?

And now I need to base a Subform on a table filtering the records on the key
value from the main form and the value selected by the combo box. I need to
be able to add records to this subform table.

"the key" value?

Does this make sense? Can someone help?
I do not think I can simlify it anymore, but if I can...

It needs amplification, not simplification. We cannot see your database and
have no idea what "the query" might be, or the "key", or how you're
referencing the "key".

 

[Dorian C. Chalom]

May I try to ask another question?

Is it possible to link a Subform to 2 unbound fields?

Thank you for putting up with me.

 

[John W. Vinson]

May I try to ask another question?

Is it possible to link a Subform to 2 unbound fields?

Yes. You can set the Master Link Field property of a subform to the name of a
main form Control, or to a series of up to ten names (of either unbound
controls or fieldnames) separated by semicolons. E.g. you could have a Master
Link Field like

txtCalcField1; txtCalcField2

where these are the names of textboxes on the form. The corresponding Child
Link Field property needs an equal number of fieldnames, again with
semicolons; but these must be actual field names from the subform's
recordsource query, not the names of controls.

Thank you for putting up with me.

Glad to be able to help.