Help with multiple forms

[Guest]

I would like to bring data in from one form to another, while the form is open, and upon execution of the "open second form
I am able to do this in the Control Source however it does not write the data to the table behind table 2
Exampl
Table1 has a opp id, when I go to open table 2 from a command button on table 1 I want all the data to be brought over that is dublicated in both tables. But I also need the data to write to the table
Thank
HLT

 

[Michel Walsh]

Hi,


Append the record to the table2 before opening the form2, or, requery
the form2 if it is already open.

To append a record, use SQL:

CurrentDb.Execute "INSERT INTO tableName( listOfFields) VALUES(
listOfValues) ; "


The owner of the forms is the user in front of the keyboard; your VBA
code is another user, as far as appending records is concerned, so,
different users won't see the job done by other users AFTER they open their
"recordset", unless they requery their recordset. So, the initial
suggestion.


Hoping it may help,
Vanderghast, Access MVP

I would like to bring data in from one form to another, while the form is

open, and upon execution of the "open second form"

I am able to do this in the Control Source however it does not write the

data to the table behind table 2.

Example
Table1 has a opp id, when I go to open table 2 from a command button on

table 1 I want all the data to be brought over that is dublicated in both
tables. But I also need the data to write to the table.

 

[Guest]

Thanks for that help, but I don't think I explained myself very well
I have a main form where an ID is autogenerated. The ID is my primary key in table 1 and the relation between table 1 and 2
When I click though (button) to the form that inputs into table 2, IF the ID is already in table 2 it populates all the data that was input before. They did this in the past using a manual cut and paste. BUT IF the ID is not in table 2 already I would like the number come over from the form for table 1 and then the other data is manually entered

I hope this is more clean
Thank
HL

----- Michel Walsh wrote: ----

Hi


Append the record to the table2 before opening the form2, or, requer
the form2 if it is already open

To append a record, use SQL

CurrentDb.Execute "INSERT INTO tableName( listOfFields) VALUES
listOfValues) ;


The owner of the forms is the user in front of the keyboard; your VB
code is another user, as far as appending records is concerned, so
different users won't see the job done by other users AFTER they open thei
"recordset", unless they requery their recordset. So, the initia
suggestion


Hoping it may help
Vanderghast, Access MV

I would like to bring data in from one form to another, while the form i

open, and upon execution of the "open second form

I am able to do this in the Control Source however it does not write th

data to the table behind table 2

Exampl
Table1 has a opp id, when I go to open table 2 from a command button o

table 1 I want all the data to be brought over that is dublicated in bot
tables. But I also need the data to write to the table