OpenForm: Where Condition

[hogan]

I am using a macro on a button to open a form using the Where Condition below.

[Forms]![SERVICE WORK ORDERS]![SKU WORK ORDER ID]

The form i am opening is a Parts Invoice form that includes the SKU WORK
ORDER ID as a foreign key. The macro works fine when there is a record with
the corresponding data in the SKU WORK ORDER ID field.

My question is this. How do you move to the next line in the macro if the
Where Condition above is not true.

Thank you.

 

[Steve Schapel]

Hogan,

Note that a Condition in your macro is different from the Where Condition
argument of an OpenForm action.

A Macro Condition determines whether an action will be executed. The
OpenForm's Where Condition describes which record the form will display on
opening - and will display no record if the Where Condition has no value.

--
Steve Schapel, Microsoft Access MVP

I am using a macro on a button to open a form using the Where Condition
below.

[Forms]![SERVICE WORK ORDERS]![SKU WORK ORDER ID]

The form i am opening is a Parts Invoice form that includes the SKU WORK
ORDER ID as a foreign key. The macro works fine when there is a record
with
the corresponding data in the SKU WORK ORDER ID field.

My question is this. How do you move to the next line in the macro if the
Where Condition above is not true.

Thank you.

__________ Information from ESET Smart Security, version of virus signature database 4202 (20090630) __________

The message was checked by ESET Smart Security.

http://www.eset.com