Update Form with data from another form on click event

[Randy.Wehnes]

Ok, have been reading posts and searching the internet for a week now and not able to get this going.

Using Access 2010, have two tables: Census and Consult.

Consult form is where data is first entered, such as Last Name First Name, Phone number etc. On this form is a check box named "Enroll"



I have an enrollment macro that opens the Enrollment form and creates a new record for the Census Table.

I created an OnClick event on the Enroll check box (Consult Form) that runs the enrollment macro. This part works fine, the enrollment form opens to a new record and permits data entry.

I want to take the data in the Consult form and put it in the correponding fields in the enrollment form to cut down on data entry.

Field name in Consult:
CLast_Name

Field name in Census:
Last_Name

I have tried to use such macro commands as SetLocalVar and SetTempVal but am not able to get the information copied over.

[pbaldy]

I think the macro command you're after is either SetValue or SetProperty (differs by version).