UtterAccess Discussion Forums > Filter 1 Form based on Another Form

Full Version: Filter 1 Form based on Another Form

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

Pugz

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.

Thanks,
J

GroverParkGeorge

Sep 17 2008, 04:35 PM

Try either
Forms!frmClaimsInput!numAdjuster
or
Me!numAdjuster

Zavenstar

Sep 17 2008, 04:37 PM

Hi

Try

DoCmd.OpenForm "frmAdjusterInfo"
DoCmd.GoToControl "txtAdjuster"
DoCmd.FindRecord Forms!frmClaimsInput!numAdjuster

Z

Edited by: Zavenstar on Wed Sep 17 17:39:34 EDT 2008.

Pugz

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.