Having trouble w/ tab page

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

Guest

I am still having trouble with this..I have a tab page and I need after I
enter the info for the last text box in the first page I need the tab to go
to the next tab page. i ws told to do it this way In the LostFocus event of
the last text box on the first page, set focus to the first text box of the
second page. I keep getting an error message. Can somwone please help me with
this.

Thanks
 
teelee said:
I am still having trouble with this..I have a tab page and I need
after I enter the info for the last text box in the first page I need
the tab to go to the next tab page. i ws told to do it this way In
the LostFocus event of the last text box on the first page, set focus
to the first text box of the second page. I keep getting an error
message. Can somwone please help me with this.

Thanks
Click to expand...

I don't recommend using the LostFocus method because it means that any time the
user leaves that control (even with their mouse) that they MUST go to the next
control on the next TabPage. If they were using Shift-Tab or the mouse this
will take them someplace other than where they wanted to go and they will mutter
about the dufus that designed the app.

Instead, place a tiny (but visible = true) TextBox on each TabPage and make it
last in the Tab Order In the GotFocus event of that control have code that
takes you to the desired control on the next TabPage. The code would look
like...

Me!DesiredControlName.SetFocus

This TextBox can be zero pixels high and wide so it cannot be "seen", but it
must have its visible property set to true so it can have focus (albeit
temporarily).

This way when the user leaves the last "real" control on each page by using the
Tab or Enter key then they will automatically be taken to the next TabPage, but
if they use Shift-Tab or the mouse then those actions behave as expected.

By the way...what is the error you are getting?
 
Thank you..it's working now. Can you help me with this...I have 2 text boxes
and when I enter the info into the first one Iwould like for the second text
box to auto fill after entering in the first one.
 
teelee said:
Thank you..it's working now. Can you help me with this...I have 2
text boxes and when I enter the info into the first one Iwould like
for the second text box to auto fill after entering in the first one.
Click to expand...

Auto fill with what?
 
For Example in my form header I have a text box that is named Dr Id and then
I have in my detail part another text box that I need to fill in with the
number that I filled in the Dr Id box.

Also, do you know anything about Parameter Value? Every time I open my form
this box pops up saying enter Parameter Value. I don't see anywhere that I
entered this.

Thanks
 
teelee said:
For Example in my form header I have a text box that is named Dr Id
and then I have in my detail part another text box that I need to
fill in with the number that I filled in the Dr Id box.
Click to expand...

In the AfterUpdate of the first TextBox

Me!SecondTextBoxName = Me!FirstTextBoxName
Also, do you know anything about Parameter Value? Every time I open
my form this box pops up saying enter Parameter Value. I don't see
anywhere that I entered this.
Click to expand...

Access assumes anything that appears to be a field reference but for which no
field with the same name actually exists must be a parameter. Consequently if
you have any references to non-existent fields (deleted or the name changed) or
if you simply mispell a field name somewhere then the parameter prompt is the
result.
 
Back
Top