Sep 17 2008, 04:14 PM
I have a control (cmbAdjuster) on frmClaimsInput that when the user double clicks I would like to open frmAdjusterInfo and go to the record for that adjuster, I tried the following code in the onDoubleClick property:
DoCmd.OpenForm "frmAdjusterInfo", , , "[txtAdjuster] = " & Form!frmClaimsInput!numAdjuster
However I get the error:
Can't find the field 'frmClaimsInput' referred to in your expression.
I know I am doing something stupid wrong however I can't figure out what it is.
Sep 17 2008, 04:35 PM
Sep 17 2008, 04:37 PM
Edited by: Zavenstar on Wed Sep 17 17:39:34 EDT 2008.
Sep 17 2008, 04:52 PM
Thanks Grover, I knew I was missing something little. It's exciting to learn this.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here