=> Basing a form on a Query or a Table

[Rhonda Fischer]

Hello,

I have a subform that I would like the user to be able
to enter data directly into. Is this possible if my
subform is based on a query or do I need to base the
subform on a Table, which means I will need to add
a couple of columns to my table to accommodate this.

Thank you very much
Rhonda

 

[Rick Brandt]

Hello,

I have a subform that I would like the user to be able
to enter data directly into. Is this possible if my
subform is based on a query or do I need to base the
subform on a Table, which means I will need to add
a couple of columns to my table to accommodate this.

Thank you very much
Rhonda

Depends on the query. Not all queries are updateable. If yours is then
you can bind the form to it and you'll be fine.