New record in second form

[Asif]

I have two forms; Form 1 and Form 2. What I want to know is that is it
possible to add a new record in Form 2 through Form 1, i.e. have a
command button in Form 1 which when clicked will add a new record to
Form 2?

Thanks

 

[Guest]

What do you mean by this? You want to add a new record to Form 2's recordset
or listbox or what?

 

[Asif]

What do you mean by this? You want to add a new record to Form 2's recordset
or listbox or what?

yes i want to add a new record to form 2's recordset

 

[John W. Vinson]

yes i want to add a new record to form 2's recordset

Then run an Append query to add the record to Form2's recordsource table, and
then requery the Form.

John W. Vinson [MVP]