UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Filter 1 Form based on Another Form    
 
   
Pugz
post Sep 17 2008, 04:14 PM
Post #1

UtterAccess Member
Posts: 26
From: Orange County
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
Go to the top of the page
 
+
GroverParkGeorge
post Sep 17 2008, 04:35 PM
Post #2

UA Admin
Posts: 19,236
From: Newcastle, WA
Try either
Forms!frmClaimsInput!numAdjuster
or
Me!numAdjuster
Go to the top of the page
 
+
Zavenstar
post Sep 17 2008, 04:37 PM
Post #3

UtterAccess Addict
Posts: 110
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.
Go to the top of the page
 
+
Pugz
post Sep 17 2008, 04:52 PM
Post #4

UtterAccess Member
Posts: 26
From: Orange County
Thanks Grover, I knew I was missing something little. It's exciting to learn this.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 08:50 AM