Update data when opening a form

[herby_one]

Hi,

I have a form which is used to input new properties data. When I tick a checkbox field this opens a history form.
I want to be able to copy the data from a few fields into the fields in the history form when its opened.
What is easiest way to do this?
I was thinking store the data (eg. landlord_ID) in a variable but am not sure how to update the field in the history form.
Any suggestions?

 

[WayneRyan]

herby,

Make the DefaultValue for the fields on the new form:

=Forms![YourMainForm]![SomeField]

Wayne

 

[herby_one]

thanks

excellent, thanks WayneRyan - worked fine