append TO a form

[SusanC]

Hi,
Is it possible to append to a form so that I can have a record from one table, query, append to a form.
Then add additional info to that record and save it as a new record in the table the form is based on?!
Thanks
Sue

 

[KeithG]

Yes, you would have to open up a recordset and input the info to the controls on the form.

 

[SusanC]

I'm not sure how I would do that?

If I change the controls on the prexisting form then the user won't be able to enter data manually will they?

 

[Dennisk]

create an append query that takes the data from one table and appends to the underlying record source for your form. you will then see those records on your form.