more than one recordsource in single form

[jerry28ph]

hi,

can we assign more than 1 recordsource in single form? if possible, can you please teach me the syntax or setting up the recordsource in the form?

Thanks,
Jerry

 

[adam.greer]

I'm not 100% sure but I don't think a form can have two recordsource's. You can however place those two source's in a query and have that one query as the source OR you can have you main form and place the second recordsource as a subform.

Could anyone confirm that?

 

[Bilbo_Baggins_Esq]

Aside from building a query with multiple record sources, you could make a sub-form within the main form which has a different record source, and you can link fields from the sub-form to fields in the main form.

 

[jerry28ph]

ok i'l try to use sub-form, since im newbie in access and my knowledge is really basic. Thanks for the help.

Regards,
Jerry

I'm not 100% sure but I don't think a form can have two recordsource's. You can however place those two source's in a query and have that one query as the source OR you can have you main form and place the second recordsource as a subform.

Could anyone confirm that?

 

[jerry28ph]

Thanks for enlightened me. ok i'l try to work it out with the subforms.
Best regards,

JErry

Aside from building a query with multiple record sources, you could make a sub-form within the main form which has a different record source, and you can link fields from the sub-form to fields in the main form.