activate form on open A2002

  • Thread starter Thread starter Brigitte P
  • Start date Start date
B

Brigitte P

I have a start up form where staff select their name and the test they wish
to take, and they then go via a command button to the appropriate test page.
The test - a tab form - opens with the first page taking name and other
demographics as well as the test number from the start up form. On page 2,
the test begins. My problem is that on page one all values are filled in
automatically, based on the start up form and an auto number field for the
test id. As soon as I answer the first question on page 2, all fields on
page one are activated and fill in correctily. But, obviously, I need to
have page one filled in before I go to page 2 so staff can confirm that this
is really what they want to do.
Question 1: Is there some code or any other way that I can activate the
fields on page one automatically on open (maybe something in the button that
opens the form from the start page.

Question 2: How can I code the test activation button that it goes to test 1
if the user selected test 1 from the combo box or to test 2 if the user
selected test 2 from the combo box, etc. I can make a button for each of the
12 tests but that seems duplicating the users effort to select the test.

As always, any help is greatly appreciated.

Brigitte P.
 
I solved problem 2 fine with some If - Then statements behind the button
that opens the text. I suppose Case Select would be better, but it's
currently working.
However, I still don't know how to activate the first Tab Control page
immediately, before the user enters any date (which would start with test
question on page 2). I tried a control button, tried requery and refresh,
but nothing works except the user starting data entry by beginning the test
(and that's too inconvenient).
Please help.
Brigitte P
 
Thanks, I looked someplace else and got it, real simple - and now I can get
some sleep. If someone else has this problem with [CLASS-TITLE] being one of
the automatically filled in field in my case:
[CLASS-TITLE].SetFocus
If IsNull([CLASS-TITLE]) Then
[CLASS-TITLE] = [CLASS-TITLE]
End If
 
Back
Top