Macro problems

[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.

 

[bhicks11 via AccessMonster.com]

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.

 

[Kevbro7189]

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

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.

 

[bhicks11 via AccessMonster.com]

I would put the criteria in the Macro Condition. When you are designing the
Macro hit View - Conditions to see the conditions column. Here's a link
with some examples.

http://office.microsoft.com/en-us/access/HP051884291033.aspx

Bonnie
http://www.dataplus-svc.com

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

Post the VBA code or Macro lines please.

[quoted text clipped - 6 lines]