I've got an Access 2010 subform with 3 combo boxes, 3 textboxes with
input masks (for a date formatted mm/dd/yyyy), and 2 check boxes. If
I click on a combo box or in a text box, the subform appears to reset
itself. If I attempt to choose an item from the combo list, the list
disappears and I have to select it again to drop the list down. If I
click in a textbox, the mask appears, then immediately disappears and
I have to click in the textbox again to bring the mask up. The only
control I don't have to click twice is the checkboxes. Once I've
clicked a second time in the combos or textboxes, then I can proceed
with data entry with no further problems.

There is no coding in the Form BeforeUpdate or BeforeInsert events.
There is coding in the AfterUpdate events and NotInList events for the
combos and textboxes. The textboxes do have coding in their
respective BeforeUpdate events.

Any idea why this behavior? Thanks for any help or advice.

Have you checked in the main form, most likely the subform control (as
opposed to the subform itself) for coding that could be causing this?

Jon
"emanning" <emanning (AT) kumc (DOT) edu> wrote

Jon, I don't know if you saw my reply on Access Monster so I'm reposting it here. (I've had trouble with Google Groups until today)

<posted 6/28/11 on Access Monster...>
Clif - thanks for the info. Unfortunately I have to use the web interface.
I'll contact Google Groups and let them know there's a problem.

Jon - thanks for your reply. In the main form, the only coding for the
subform is to initially make it invisible (which is in the Form Load event).
Then there's coding to requery it when the subform is needed. The subform is
displayed when the user selects a name from a combobox on the main form. The
AfterUpdate event of this combo requeries the subform to display the correct
records in the subform. The subform is linked to the main by the Master and
Child properties. I did change it to link programmatically thinking that
might be the problem. But it wasn't.

FWIW, this database was orginally an adp. I'm converting it to an accdb. I
copied this main form/subform from the adp to the accdb. I do have other
subforms similar to this that work just fine.

I didn't get your previous reply. Please post your code and I'll see if I
can reproduce the problem

Jon
"emanning" <emanning (AT) kumc (DOT) edu> wrote