Combobox1 selects into a cursor. Use that cursor name in the where clause of
the select statement in combobox2.
In the valid event of combobox1, call the requery method of combobox2.
The initial queries are processed after the form load event. They only requery
when told to.
HTH
Tracy
On May
My data is in a table called labels with three fields, space, location, and
label.
I thought my problems were solved but now when I setup my second combo box
with the row source set to
select location distinct from labels where labels.space =
thisform.combo1.value = labels.space into cursor T2
I
Tracy,
I did another test form using days of the week like yours. I still got the
error. Then I removed the quotes around the CSL statement and it worked!
Somewhere in my surfing I had read that the quotes were required but that
is apparently incorrect.
More details:
1. When does the SQL
Hi Joe,
don't put in quotes or double quotes the sql statement!
Gianni
On Sat, 22 May 2021 15:03:50 -0400, Joe Yoder wrote:
I want to use an sql select statement as the row source for a combo box..
- When I set the row source type to 3-SQL and enter the row source as
"select space
Hi Joe,
Those settings are working for me in my quick test.
Does the SQL statement you have in the RowSource work in code?
As a test I built a cursor with the days of the week in it in the Load event
of a form.
CREATE CURSOR ComboBoxData (id i, displaytext c(30))
I set the
5 matches
Mail list logo