Taking data from one form to another

[kev]

I have a table with program date within it
and I am trying to import that date into another form and then into the table of the second form I'm sure its easy but I cant see the wood for the trees

please help
Thanks in advance

 

[Chris RR]

You need to do this in VBA. If you have a button that opens the second form, you'll need code something like this in its Click event:
DocName = "fSecondForm"
DoCmd.OpenForm DocName, , , , acAdd
Forms![fSecondForm]![Dt_Somesuch] = Me.Dt_Program

 

[kev]

Hi Thanks for that

I have decided to do it at table level

I will post on Table forum

would you know if it is possible to get a field to set as default to a value in another table

Thanks Kev

 

[TGHockett]

Chris --- am curious why you say one has to use VBA to pass the values from one form to another form. I am using Acc2k and have accomplished this via macro using the setvalue action-- careful consideration is that the macro doesn't close the first form until the 2nd form values have been set, of course.

VBA-challenged TGH