GoControl Problem

[open a adobe file from a command button]

I'm trying to use a macro to set the focus to a control using this code:
Macro Name: No Date
Condition: IsNull([ToDaysDate])
CancelEvent
GoToControl: ToDaysDate

I get my message box but when I click 'OK' it moves on the the person first
name

 

[tina]

there's no message box in the macro posted below. how about posting the
entire macro? also, what event are you calling the macro from?

and btw, you don't need to call a function to check the value of
[ToDaysDate]. a simple conditional expression should work just as well, as

[ToDaysDate] Is Null

hth


"open a adobe file from a command button"

 

[open a adobe file from a command button]

Tina, thanks for the reply. I have a form with some input txtboxes, the
first one is ToDaysDate, I need this date to be filled out because it gets
used a little later on so on the 'on lost focus' properity of ToDaysDate I
send it to a macro called 'NoDate', the condition is 'is not
null([ToDaysDate]), the next line is a message box asking them to enter a
date, the next line is the 'GoToControl', the controlname is 'ToDaysDate',
but it goes to the next tab stop which is the person's first name. It's a 3
line macro and I don't see what I'm doing wrong

there's no message box in the macro posted below. how about posting the
entire macro? also, what event are you calling the macro from?

and btw, you don't need to call a function to check the value of
[ToDaysDate]. a simple conditional expression should work just as well, as

[ToDaysDate] Is Null

hth


"open a adobe file from a command button"

I'm trying to use a macro to set the focus to a control using this code:
Macro Name: No Date
Condition: IsNull([ToDaysDate])
CancelEvent
GoToControl: ToDaysDate

I get my message box but when I click 'OK' it moves on the the person first
name

 

[tina]

your problem is that the LostFocus event cannot be cancelled. so the
CancelEvent action has no effect. try moving the macro to the control's Exit
event instead.

hth


"open a adobe file from a command button"

Tina, thanks for the reply. I have a form with some input txtboxes, the
first one is ToDaysDate, I need this date to be filled out because it gets
used a little later on so on the 'on lost focus' properity of ToDaysDate I
send it to a macro called 'NoDate', the condition is 'is not
null([ToDaysDate]), the next line is a message box asking them to enter a
date, the next line is the 'GoToControl', the controlname is 'ToDaysDate',
but it goes to the next tab stop which is the person's first name. It's a 3
line macro and I don't see what I'm doing wrong

there's no message box in the macro posted below. how about posting the
entire macro? also, what event are you calling the macro from?

and btw, you don't need to call a function to check the value of
[ToDaysDate]. a simple conditional expression should work just as well, as

[ToDaysDate] Is Null

hth


"open a adobe file from a command button"

I'm trying to use a macro to set the focus to a control using this code:
Macro Name: No Date
Condition: IsNull([ToDaysDate])
CancelEvent
GoToControl: ToDaysDate

I get my message box but when I click 'OK' it moves on the the person first
name