Need help with form header

  • Thread starter Thread starter Brenda Swaim
  • Start date Start date
B

Brenda Swaim

Does anyone know if you can move from a form header to the
detail portion of your form (without using code)? I have
put a combo lookup object in my form header (bcs I don't
want it to print when the form is printed) for record
retrieval and want to move to the form (actually a
subform) in my detail area to enter data. I have a macro
set to run upon leaving the focus of the combo lookup box
that is supposed to take me first to the subform object,
then to the desired field of that subform. The problem
is, I can't seem to get the focus off of this combo box.
I've looked for help in the KB & other sites, but can't
find anything that addresses this. Any thoughts would be
appreciated, but I have no knowledge of programming, so it
has to be simple.
 
Hi,
Can you not just set the tab order of the form so that you can simply tab from your combo
to the desired control?

HTH
Dan Artuso, MVP
 
Brenda Swaim said:
Does anyone know if you can move from a form header to the
detail portion of your form (without using code)? I have
put a combo lookup object in my form header (bcs I don't
want it to print when the form is printed) for record
retrieval and want to move to the form (actually a
subform) in my detail area to enter data. I have a macro
set to run upon leaving the focus of the combo lookup box
that is supposed to take me first to the subform object,
then to the desired field of that subform. The problem
is, I can't seem to get the focus off of this combo box.
I've looked for help in the KB & other sites, but can't
find anything that addresses this. Any thoughts would be
appreciated, but I have no knowledge of programming, so it
has to be simple.
Click to expand...

I expect your problem is that the combo box is the only control in the
header section that is capable of receiving the focus. Thus, since
tabbing takes places only within the current section, no amount of
tabbing will cause the combo box to lose focus.

What you can do is add another text box to the form header section.
Leave it unbound and with its Visible property set to Yes, but set its
Special Effect property to Flat, and most important, set its Height and
Width properties both to 0. Yes, that's right, 0. Now the text box
will be visible and enabled as far as Access is concerned, but not in
fact visible to the user. Since this text box is capable of receiving
the focus, the combo box can now lose focus, triggering its LostFocus
event and the macro you wrote to set the focus into the subform.

You may want to ensure that the dummy text box can't really get the
focus by setting a macro or event procedure for its GotFocus event to
set the focus to the combo box.
 
Back
Top