Unbound Combo Box Quiery

[Bob]

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

I have a drop down combo box that list customers that are in (Active) mode,
so when the customer has (Active) selected under his address he appear in
the drop down box and can be selected to go to his record, But if the first
50 records don't have a (Active) selected and the 51 does you have to scroll
down about 50 spaces to select his name, Can the first name that has active
selected be at the top of the list and so on... Thanks

Thanks in advance.........Bob Vance

 

[Mike Revis]

In the record source for you combobox you could try SELECT YourFieldName
FROM YourTableName WHERE Active = true (assuming active is a yes/no data
type). Substitute your field/table name. This should only return records
where active is true.

 

[Bob]

Yes the true ones are being shown but the Finished (false) are leaving gaps,
TIA Bob

 

[Mike Revis]

Hi Bob,
I'm not clear on what you mean by the "finished (false) are leaving gaps".
The ones where Active=False shouldn't even be showing in the list.

 

[Bob]

Sorry ,When I select [Finished] on the form, that person does not show in my
drop down box list, BUT it leaves a blank line gap, so if form number 4
,[finished]is selected then in my drop down list there is a blank line gap
between 3 and 5
TIA, Bob Vance

 

[Mike Revis]

Bob,
Now I am really confused.
What is [finished]? Is it a command button that you click after you have
entered the data to indicate you are "finished"?
What do you expect to happen when you "select" [finished]?
Perhaps you can post the record source for your combo box.

Sorry I'm not more help. Perhaps someone else has an idea.

Mike

Sorry ,When I select [Finished] on the form, that person does not show in my
drop down box list, BUT it leaves a blank line gap, so if form number 4
,[finished]is selected then in my drop down list there is a blank line gap
between 3 and 5
TIA, Bob Vance

Hi Bob,
I'm not clear on what you mean by the "finished (false) are leaving gaps".
The ones where Active=False shouldn't even be showing in the list.


appear
in