Form Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't understand what you mean by the in the after update event of the
scheduled appointment check box. Where is that?

To have Registered button to appear only after the scheduled appointment
check box is checked, first set the visible property of the Registered button
to No.

The in the after update event of the scheduled applintment check box, place
the following code:

If me.TheNameOfYourCheckBox = true
me.TheNameOfYourRegisteredButton.Visible = True
Else
me.TheNameOfYourRegisteredButton.Visible = False
EndIf

On the other issue, I am not sure just what you mean by "next page". If you
can provide a little more info perhaps someone can help.

--
HTH

Mr B

In my form, I have a scheduled appointment and walk-in appointment radio
button. I also have a Registered check box button on the form.

I want to know how to make the registered button appear only when the
scheduled appointment check box is selected.

And I would like to know how to make going to select a scheduled or walkin
appointment mandatory, before proceeding to the next page. I know that there
is some code involved.
 
You have posted this as a new post and also posted another post to the Forms
Design thread when you already had another post on this going. It is much
easier for the people in the Access Newsgroups to help if you will post one
post for your question. Then continue to post to that same posting thread so
all can contribute and perhaps help.

As for where to put the code, hopefully Doug has provided you with the
answer in the Forms Design thread.
 
First of all, sorry for the mix up. I was not seeing my post after refreshing
after 10mins, so I posted it again.

I wanted to change my code a little. Currently I have the scheduled option
button, and it has a field that asks for the time to shows up after it is
selected. I want to know if I could build the code to have the Registered
button appear after someone has entered a time in it?

And once again, sorry for the mishap
 
y previous post was only for informtaion, not for anything else. We all make
mistakes.

As for having something to be shown after a date or other entry: In design
view of your form, set the visibility property of the control you want hidden
to "No", then in the AfterUpdate event of the control that you want users to
complete before displaying other options:

Me.NameOfControlToDisplay.Visible = true

If you need to verify that they have made an entry in a text box, you can
use something like:

If Not IsNull(me.NameOfControlBeingUpdated) then
Me.NameOfControlToDisplay.visible = true
Else
Me.NameOfControlToDisplay.visible = false
end if

You could just as easily have the control you do not want them to use until
something else is entered to be disabled instead of being invisible. This
lets the user know that other options are available but not enabled yet.
They get a clue that they need to complete data entry.

In this case you can simply substitute "enabled" for "visible" in the
instructions above.
 
GREAT!! It works. One last question. This is the first page from the
Registration MDE file. If it was registered, how can I have this message
displayed to other form pages? And how can I report off of it?
 
I'm not sure that I understand your question.

Just what are you refering to when you say "first page". You also refer to
MDE file. MDE files cannot be modified. Only MDB type files can be modified.
Plase provide a little more infor and I or someone else will try to help. If
you are wanting the same button to be seen when the user moves to another
page of your form, place the button in the footer of the form. You will need
to display the form header and footer.

As for reporting, I assume you are storing the data in a table. You will
need to create a report from either the table or a query that is extracting
data from the table. You would then have a button on a form that would run
the report.
 
Back
Top