B
boomtap via AccessMonster.com
I use the IIF command quite a bit in queries. Is there a simular command
(basically an IF / THEN statement) that can be used in a form?
(basically an IF / THEN statement) that can be used in a form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham R Seach
If you're talking about using something in a ControlSource, RecordSource or
RowSource, then you can use IIF(), Choose(), or Switch(). If you're talking
about using it in VBA, you can use either IIF(), Choose(), Switch(), or the
If..End If construct, or the Select Case...End Select construct.
Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
RowSource, then you can use IIF(), Choose(), or Switch(). If you're talking
about using it in VBA, you can use either IIF(), Choose(), Switch(), or the
If..End If construct, or the Select Case...End Select construct.
Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia
B
boomtap via AccessMonster.com
Switch worked amazingly well. Thanks for the help.