Form Open

  • Thread starter Thread starter Bernd Smits
  • Start date Start date
B

Bernd Smits

Hi,
I made a combobox for name research with a associate form that opens after
an action and it works , but I have still a few questions:
1) I would like to double-click before the relative form is open, but now
the
form opens directly just when I click one time. How to do?;
2) I would like that the form opens on the same form as the combobox,
exactly I want that the form opens below the combobox. How can I do that?
With the clause "where"?
3) I would like that when I'm writing (first, second, etc. letter) of the
name of the person that I'm searching about, there opens below the combobox,
istantly a list of the names that begins with letter that I have typed. How
can I do that?.
Thanks
Bernd
 
. . . combobox ... with a associate form
that opens after an action and it works
Click to expand...

"an action"?
1) I would like to double-click before
the relative form is open, but now
the form opens directly just when
I click one time. How to do?;
Click to expand...

Then clearly, you have the code that opens the associated Form in some event
other than DoubleClick. I'd wager, if you moved it to the DoubleClick event,
it would work the way you wish. (The most common way is to put the code in
the AfterUpdate event of the Combo Box, which will work as you describe.)
2) I would like that the form opens on
the same form as the combobox, exactly
I want that the form opens below the
combobox. How can I do that?
Click to expand...

Put that Form in a Subform Control that you locate on the main Form where
the ComboBox is located. You can, if you wish, manipulate its Visible
property so that even the empty Form isn't shown in the Subform until a
record is selected.

Alternatively, just put your search ComboBox in the Form Header... the
ComboBox wizard will do everything else you need to locate the particular
record.
With the clause "where"?
Click to expand...

The WHERE clause is part of a Sequential Query Language, for specifying
selection criteria. It has nothing to do with Forms or screen locations.
3) I would like that when I'm writing
(first, second, etc. letter) of the name
of the person that I'm searching about,
there opens below the combobox,
istantly a list of the names that begins
with letter that I have typed. How
can I do that?.
Click to expand...

What you describe is the normal behavior of a Combo Box whose items are
based on a Table or Query specified in its RowSource property, with its
AutoExpand property set to Yes (which is the default setting). If yours is
NOT working this way, check the AutoExpand property, and the property that
specifies how many items to show in the drop-down list.

Larry Linson
Microsoft Access MVP
 
Back
Top