Inconsistent focus in fields

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have put together several useful databases, but the
encountered the same problem in each. On opening an input
form there is no focus until clicking into the field (I
am quite aware of tab order and setting the focus at zero
on the first field - thats not the issue). Also, when
reaching the end of a sub-form and opening a new record,
the focus doesn't consistently return to the first field
in the parent form. The silly little navigation buttons
that Microsoft place at the foot of the form do seem to
function more consistently (but not entirely), but decent
sized buttons inserted from the toolbox to do exactly the
same tasks NEVER open a form with a focus on a field. The
same is true in sample databases that I haven't otherwise
tampered with at all.

Anyone have any clues on this?

Regards, Keith
 
Keith

No idea about the "inconsistency" angle. Have you tried using something
like:

Me!txtMyFirstControl.SetFocus

in the form's Activate event?
 
Hi Jeff,

Sorry to seem so rude. I haven't deliberately ignored you - just didn't
receive a notification and thought no-one had replied. I found my way back
here almost by accident on another issue.

No, I hadn't previously tried your suggestion, But I just did and clearly
don't know how to. Can you treat me like a dummy and explain the syntax and
the "how to?" I have tried substituting the field name for "myfirstcontrol"
with and without the "txt" but just get a message saying it can't find that
macro. I've tried typing it exactly as you typed, character-for-character -
same result. The "Me!" has me stumped. Anyway I played with the macro
builder, selecting "go to a control", naming it below, of course, and typing
the macro name in the event box for "on activate", but that didn't do
anything either.

My highest achievement in Visual Basic is cautiously amending and correcting
recorded macro code in Excel modules!

Regards, Keith

:
 
Back
Top