Forms-Refreshing a new page

[Guest]

How do I get a new page in a form to 'refresh' so that a command button on
the new page becomes invisible again when the text box on the new page is
blank?

My idea is to create a text box on a form and when the text box is filled in
with information, say a date, to have a command button become visible. The
command button would invite the user to click so that a letter would be
printed. By the same token, as the user click forward or backward thru the
pages, if that text box were empty on any page, the command button would be
invisible. If the text box contained data, say a date, the command button
would become visible.

Your help is appreciated.

Thanks.

 

[Ed Robichaud]

You could use the form's OnCurrent event and the date control's AfterUpdate
event to set the visible property of the command button.

Like:

If Isnull(Me!MyDateControl) Then
Me!MyButton.Visible = False
Else
Me!MyButton.Visible = True
End If

-Ed

 

[Guest]

You want the form's On Current event.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.