Form pulls info into fields based on ID number

[arothacker]

I have a form called "Headcount" that displays employee information. It has a drop down field called "Selection". When the user picks a value from the drop down a form called "New" pops up for them to fill in a new line of information.

Is there a way for the "New" form to pull in information from the record that the drop down was selected for? This information will then be submitted as a new record.

For example, there is a record with the following information:
ID:1234
Location:Miami
Type:Salary



The employee is leaving so the user will select "Leaving" from the drop down and the "New" form pops up and automatically pulls in the ID, Location, and Type. I've played around with DLookups but haven't been too successful.

Thanks!!

[orange]

In the after update on the drop down,
you would open the "NEW Form" with openargs based on the drop down.

See this for more detail

[arothacker]

Thanks for this...I'm a little confused as how to write the openargs. Both forms have the fields ID, Location, and Type. The user will click the drop down value and the "New" form will pop up. I want the data from the record selected to copy over to the "New" form. Do you have to do something with the primary key?

My code is so far is:
If Selection.Value = "OPEN" Then
DoCmd.OpenForm "New", acNormal,,,acFormAdd,,

Then I get stuck as how to reference the openargs...what would be an example if for the record selected on the "Headcount" form, copy over the value for "Location" into the "New" form

[orange]

See this tip from FMC.

You can also google to find other examples.