ComboBox in bounded continuous form avoids to choose any entry

[Erhy]

Hello,
perhaps a very first question:

In a form based on a query, I place a ComboBox which shows entries
of a query
( RowSourceType = "Table/Query"
RowSource = "SELECT Spuren.Spur FROM Spuren;"
)

But I'm not able select any of the shoen values.
I miss also an execution of the click event.

Thank you for any help
Erhy

 

[John W. Vinson]

On Tue, 6 Feb 2007 17:22:42 +0100, "Erhy" <erhard _ glueck _

Hello,
perhaps a very first question:

In a form based on a query, I place a ComboBox which shows entries
of a query
( RowSourceType = "Table/Query"
RowSource = "SELECT Spuren.Spur FROM Spuren;"
)

But I'm not able select any of the shoen values.
I miss also an execution of the click event.

Thank you for any help
Erhy

A Combo Box lets the user select a record or a value from one place
(the combo's Row Source) and store that value in another place - its
Control Source.

What do you want to do with Spur once the user has selected it?

The Click event is not particularly useful for a combo box; if you
want to do something with the value that the user has selected, use
the AfterUpdate event.

John W. Vinson [MVP]

 

[Erhy]

Thank you John!
The error, I found it.
The form AllowEdits property has to be true.
I thought this property belongs only to the data grid.
Greetings from Austria, Europe
Erhy