B
Brian C
I have form1 based upon table1 and form2 based upon table2.
I want to use data input in form1 to get a record from
table1 and if a certain value exits go to form2. Data is
then input in form2 and used to create a record in table2.
I then want to go update the read from table1 with some of
the data from the table2 record.
How do I achieve this?
Do I have to keep form1 open switch to form2 and then
switch back to form 1?
How do I ensure that the original form1 is activated and
not a new form1 so that the record is available?
How do I make the data from form2 available in form1 to
update the record?
I assume that I would have to do this using code so in
what events for each form would I piut the code?
How do I switch between forms using Access Basic code?
By the way could I somehow make the record selected from
table1 in form1 available in form2 so that I don't have to
keep form1 open and switch back?
Thanks for your help.
I want to use data input in form1 to get a record from
table1 and if a certain value exits go to form2. Data is
then input in form2 and used to create a record in table2.
I then want to go update the read from table1 with some of
the data from the table2 record.
How do I achieve this?
Do I have to keep form1 open switch to form2 and then
switch back to form 1?
How do I ensure that the original form1 is activated and
not a new form1 so that the record is available?
How do I make the data from form2 available in form1 to
update the record?
I assume that I would have to do this using code so in
what events for each form would I piut the code?
How do I switch between forms using Access Basic code?
By the way could I somehow make the record selected from
table1 in form1 available in form2 so that I don't have to
keep form1 open and switch back?
Thanks for your help.