I know this has been discussed here a million times before but I am not finding an answer to my problem (at least not one my little brain can understand).
I have a main form for entering Employer Information (frmEmployers) and this form has a command button on it for opening a form to enter Retirement Plan information (frmRRSP).
Originally the Employer Form did not have a textbox for displaying the EmployerID (PK) but I was forced to add one (txtEmployerID) (Visible=No) when I used the wizard for adding the command button.
The Employer form has tblEmployer as its recordsource and the RRSP form has tblRRSP as its recordsource.
The RRSP form that gets opened with the command button has Fields for RRSP Rate and the Dates the RRSP Rate is in Effect. It does not have a textbox for displaying the EmployerFK from the main form. Nor does it have a textbox for displaying the RatdeID (PK from the RRSP table).
The wizard asked me to choose which fields contain matching data to use for lookup, I chose txtEmployerID from frmEmployers and EmployerFK from frmRRSP and linked them with the "<->" button in the wizard.
I would like to have EmployerID (PK field from the Employer Table) be transferred to the EmployerFK field of the RRSP Table. This isn't happening. Why not?
I have tried adding a textbox to the RRSP form and setting its controlsource as EmployerFK. This did not work. I have setup a relationship between the Employer Table (EmployerID field) and the RRSP Table (EmployerFK field).
Do I need to use OpenArgs? If I do, how? I can't get the syntax quite right.
TIA
John V