editable textboxes, add record to table

[Ketaki]

Hi,

I have the data source of my MS Access form as a query. I
want textboxes on this form to be editable (which they are
not right now, dont know how to do that) and then maybe
when the user hits a button, these textboxes should be
stored as a record in a table. Can this be done?

Thanks,
Ketaki

 

[John Vinson]

Hi,

I have the data source of my MS Access form as a query. I
want textboxes on this form to be editable (which they are
not right now, dont know how to do that) and then maybe
when the user hits a button, these textboxes should be
stored as a record in a table. Can this be done?

If the Query is an updateable query, no button and no special
programming is necessary. Could you post the SQL of the query upon
which the form is based? If it's two tables in a one to many
relationship, could you consider using a Form for the "one" table and
a Subform for the "many"?