IF Statement - Microsoft Access / VBA

How does one phrase this IIf statement in a Macro

IIf([Field]="2", Open Form 1, Open Form 2)

If field="2"
Then Open Form 1
Otherwise anything but "2"
(Anything meaning any type of Chracter Number, Letter Whatever)
Open Form 2

Thanks
DS

Nov 13 '05 #1

Subscribe Post Reply

2028

Paul

DONT USE MACROS...USE CODE.

Make a button and on the OnClick Event do the following:

If field2 = "2" then
docmd.openform "Form1"
Else
docmd.openform "Form2"
End If

Thats it.

HTH
Paul

"DS" <bo******@optonline.net> wrote in message
news:bU**********************@news4.srv.hcvlny.cv. net...

How does one phrase this IIf statement in a Macro

IIf([Field]="2", Open Form 1, Open Form 2)

If field="2"
Then Open Form 1
Otherwise anything but "2"
(Anything meaning any type of Chracter Number, Letter Whatever)
Open Form 2

Thanks
DS

Nov 13 '05 #2

Paul wrote:

DONT USE MACROS...USE CODE.

Make a button and on the OnClick Event do the following:

If field2 = "2" then
docmd.openform "Form1"
Else
docmd.openform "Form2"
End If

Thats it.

HTH
Paul

"DS" <bo******@optonline.net> wrote in message
news:bU**********************@news4.srv.hcvlny.cv. net...
How does one phrase this IIf statement in a Macro

IIf([Field]="2", Open Form 1, Open Form 2)

If field="2"
Then Open Form 1
Otherwise anything but "2"
(Anything meaning any type of Chracter Number, Letter Whatever)
Open Form 2

Thanks
DS

Thanks,
I'll give it a whirl.
DS

Nov 13 '05 #3

Ken Snell

In the filename argument of the OpenForm macro action:

=IIf([Field]=2, "Form 1", "Form 2")

--

Ken Snell
<MS ACCESS MVP>

"DS" <bo******@optonline.net> wrote in message
news:bU**********************@news4.srv.hcvlny.cv. net...

How does one phrase this IIf statement in a Macro

IIf([Field]="2", Open Form 1, Open Form 2)

If field="2"
Then Open Form 1
Otherwise anything but "2"
(Anything meaning any type of Chracter Number, Letter Whatever)
Open Form 2

Thanks
DS

Nov 13 '05 #4

DS wrote:

Paul wrote:
DONT USE MACROS...USE CODE.

Make a button and on the OnClick Event do the following:

If field2 = "2" then
docmd.openform "Form1"
Else
docmd.openform "Form2"
End If

Thats it.

HTH
Paul

"DS" <bo******@optonline.net> wrote in message
news:bU**********************@news4.srv.hcvlny.cv. net...
How does one phrase this IIf statement in a Macro

IIf([Field]="2", Open Form 1, Open Form 2)

If field="2"
Then Open Form 1
Otherwise anything but "2"
(Anything meaning any type of Chracter Number, Letter Whatever)
Open Form 2

Thanks
DS

Thanks,
I'll give it a whirl.
DS

It Works Great! Thank You.
DS

Nov 13 '05 #5

Ken Snell wrote:

In the filename argument of the OpenForm macro action:

=IIf([Field]=2, "Form 1", "Form 2")

Thank You, Just what I needed.
DS

Nov 13 '05 #6

Similar topics

PEP new assert idiom

by: Fábio Mendes | last post by:

I'm sorry if it's an replicate. Either my e-mail program is messing with things or the python-list sent my msg to /dev/null. I couldn't find anything related in previous PEP's, so here it goes a...

Python

Return statement twice in the same expression

by: Nerox | last post by:

Hi, If i write: #include <stdio.h> int foo(int); int main(void){ int a = 3; foo(a); }

C / C++

"with" statement, extending prototype

by: eman1000 | last post by:

I was recently looking at the prototype library (http://prototype.conio.net/) and I noticed the author used the following syntax: Object.extend(MyObj.prototype, { my_meth1: function(){},...

Javascript

pre-PEP: The create statement

by: Steven Bethard | last post by:

The PEP below should be mostly self explanatory. I'll try to keep the most updated versions available at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

updated pre-PEP: The create statement

by: Steven Bethard | last post by:

I've updated the PEP based on a number of comments on comp.lang.python. The most updated versions are still at: http://ucsu.colorado.edu/~bethard/py/pep_create_statement.txt...

Python

PEP 359: The "make" Statement

by: Steven Bethard | last post by:

Ok, I finally have a PEP number. Here's the most updated version of the "make" statement PEP. I'll be posting it shortly to python-dev. Thanks again for the previous discussion and suggestions!...

Python

Updated PEP 359: The make statement

by: Steven Bethard | last post by:

I've updated PEP 359 with a bunch of the recent suggestions. The patch is available at: http://bugs.python.org/1472459 and I've pasted the full text below. I've tried to be more explicit about...

Python

ASP Type mismatch error with SELECT...FOR UPDATE statement

by: Steve | last post by:

ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement I got ASP error number 13 when I use the SELECT...FOR UPDATE statement as below. However, if I use SELECT statement without...

ASP / Active Server Pages

Definition of expression and statement.

by: dspfun | last post by:

Hi! The words "expression" and "statement" are often used in C99 and C- textbooks, however, I am not sure of the clear defintion of these words with respect to C. Can somebody provide a sharp...

C / C++

statement values

by: florian.loitsch | last post by:

According to the spec Section 14 the production SourceElements:SourceElements SourceElement is evaluated as follows: 1. Evaluate SourceElements. 2. If Result(1) is an abrupt completion, return...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA