ComboBox results

[Guest]

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

It looks like there is no records with tblWorkOrders.Status "Open".

 

[Guest]

You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

 

[Guest]

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

If I remove the Where clause I get a list of all work orders but as soon as I
try to enter a "Where" clause to only get the "Open" work orders I get the
previously sent error message. The table is "tblWorkOrders", the field is
"Status" and valid data is "Open". Help please.

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

What I normally do is create the query first in design view, view it and
then select it from the list in the "data" properties of the combo (just so I
know the information is correct).

I am at a loss as to why this is happening.

Are you sure the column you are selecting to be stored in the table is valid
for the field.

If I remove the Where clause I get a list of all work orders but as soon as I
try to enter a "Where" clause to only get the "Open" work orders I get the
previously sent error message. The table is "tblWorkOrders", the field is
"Status" and valid data is "Open". Help please.

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

:


You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

Thanks
I tried using a Query instead of my Select statement in the Row Source and
it worked perfectly. Thanks mucho

What I normally do is create the query first in design view, view it and
then select it from the list in the "data" properties of the combo (just so I
know the information is correct).

I am at a loss as to why this is happening.

Are you sure the column you are selecting to be stored in the table is valid
for the field.

If I remove the Where clause I get a list of all work orders but as soon as I
try to enter a "Where" clause to only get the "Open" work orders I get the
previously sent error message. The table is "tblWorkOrders", the field is
"Status" and valid data is "Open". Help please.

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

:

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

:


You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

Hi Steve,

I can't swear to it because I've never tried it your way, but I've always
used this order: Select somefield(s) from sometable where somecondition
order by somefield(s).

You put the where clause last.

Could that make a difference?

CW

Thanks
I tried using a Query instead of my Select statement in the Row Source and
it worked perfectly. Thanks mucho

What I normally do is create the query first in design view, view it and
then select it from the list in the "data" properties of the combo (just so I
know the information is correct).

I am at a loss as to why this is happening.

Are you sure the column you are selecting to be stored in the table is valid
for the field.

If I remove the Where clause I get a list of all work orders but as soon as I
try to enter a "Where" clause to only get the "Open" work orders I get the
previously sent error message. The table is "tblWorkOrders", the field is
"Status" and valid data is "Open". Help please.

:

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

:

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

:


You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

Cheezie
Thanks for the thought. I'll try it next time.
Steve

Hi Steve,

I can't swear to it because I've never tried it your way, but I've always
used this order: Select somefield(s) from sometable where somecondition
order by somefield(s).

You put the where clause last.

Could that make a difference?

CW

Thanks
I tried using a Query instead of my Select statement in the Row Source and
it worked perfectly. Thanks mucho

What I normally do is create the query first in design view, view it and
then select it from the list in the "data" properties of the combo (just so I
know the information is correct).

I am at a loss as to why this is happening.

Are you sure the column you are selecting to be stored in the table is valid
for the field.


:

If I remove the Where clause I get a list of all work orders but as soon as I
try to enter a "Where" clause to only get the "Open" work orders I get the
previously sent error message. The table is "tblWorkOrders", the field is
"Status" and valid data is "Open". Help please.

:

I sometimes now get the following error
Syntax error (missing operator) in query expression '[Work Order Number]
where tblWorkOrders.Status="Open"

:

I have made sure that there are rows with Status= "Open" and even set Column
Headers to display. The number of columns was set to 3 and the widths set and
the Bound Column is set to 1. No display on the form. I'm dumbfounded or
maybe just dumb.

:


You are selecting three columns.

In the format list in the properties set the number of columns to "3" and
change the widths.

In the data tab set the "bound column" to the appropriate number

--
"Loose Change 2nd Edition" has been seen by almost 7 million people on
Google video


:

I have a ComboBox on a form with the following in the Row Source "SELECT
tblWorkOrders.ID, tblWorkOrders.[Work Order Number],
tblWorkOrders.Description FROM tblWorkOrders ORDER BY [Work Order Number]
Where tblWorkOrders.Status="Open"". The box opens up blank. What am I missing?

 

[Guest]

Hi CW,

You nailed the issue. Good catch!


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________