Open form issue

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I have a form (frmDemographics) used to enter client demographic info. On
the form are also 2 command buttons used to open 2 additional forms. One
form (frmTests) is a form for test data, the other (frmEval) is for course
evaluation data. I'm currently passing on the ClientID from frmDemographics
to each of the other forms by setting the default value of ClientID on those
forms. So, for instance, the ClientID field on frmTests is set to
=Forms!frmDemographics!ClientID. What I'd like to do though is allow users
to access frmEval from either frmDemographics OR from a command button on
frmTests, so I need a way to set the default value of ClientID on frmEval to
EITHER =Forms!frmDemographics!ClientID OR =Forms!frmTests!ClientID. Is there
a way to do that?
 
Try this --
=IIF(Forms!frmDemographics!ClientID Is Null, Forms!frmTests!ClientID,
Forms!frmDemographics!ClientID)
 
Back
Top