Macro problems

  • Thread starter Thread starter Kevbro7189
  • Start date Start date
K

Kevbro7189

I have a check box, when it is clicked on I want it to open a form. I have
that part working I'm using a Macro. The problem I have is I only want the
form to open if [another] is <> to "X" and when the [checkbox] is Yes. I
have tried using the Where Condition but the form opens no matter what the
conditions are.
 
In the Maco

Action: OpenForm
Form Name: DIFMCREATED
View: Form
Filter Name: (Blank)
Where Condition: [Forms]![ON ORDER]![ERC]<>"XB3"
Data Mode: (Blank)
Window Mode: Normal



bhicks11 via AccessMonster.com said:
Post the VBA code or Macro lines please.

Bonnie
http://www.dataplus-svc.com
I have a check box, when it is clicked on I want it to open a form. I have
that part working I'm using a Macro. The problem I have is I only want the
form to open if [another] is <> to "X" and when the [checkbox] is Yes. I
have tried using the Where Condition but the form opens no matter what the
conditions are.
Click to expand...
Click to expand...
 
Back
Top