auto transfer data

[dinadvani via AccessMonster.com]

Hi,

I need your help to resolve some issues. 1 have 2 tables and 2 forms.

table 1 is named as tblexp and is linked to form1
table 2 is named as tblinc and is linked to form2

In form 1 i have a button that goes to form 2, now when a user clicks this
button i want that 2 fields which are common in both of these forms and they
help in identifying records gets auto tranfer to form 2. so that is reduces
work.

please provide me some assistance ASAP

Regards,
DA

 

[dinadvani via AccessMonster.com]

Please Please Please Help:::::

Hi,

I need your help to resolve some issues. 1 have 2 tables and 2 forms.

table 1 is named as tblexp and is linked to form1
table 2 is named as tblinc and is linked to form2

In form 1 i have a button that goes to form 2, now when a user clicks this
button i want that 2 fields which are common in both of these forms and they
help in identifying records gets auto tranfer to form 2. so that is reduces
work.

please provide me some assistance ASAP

Regards,
DA

 

[Douglas J. Steele]

It's not really clear to me what you're trying to do, but if Form2 is
already open, you can simply refer to the controls on it and set them:

Forms!Form2!Text1 = Value1
Forms!Form2!Text2 = Value2

If it's not already open, you could concatenate the two values, pass them as
the OpenArgs argument in your DoCmd.OpenForm statement, and then parse their
values out and populate the fields in the Open event of Form2. (or you could
simply open Form2 and then use the statements above)