can i have more than 1 record source per form??

[reservedbcreater]

can i have more than 1 record source per form??

like i have a few feilds/controls that need to append data to a different
table than all the other controls/fields on the form

 

[Ken Snell [MVP]]

No a form can have only one recordsource at a time. If you cannot include
the other table's fields in the query that serves as the form's
RecordSource, then you will need to use programming (VBA or macro) to put
the data into those fields.

But to assist you, you'll need to give us more details about your setup and
what you're doing.

 

[reservedbcreater]

thnaks