Unbound Combo Box Quiery

B

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
 
M

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.
 
M

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.
 
B

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
 
M

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
Bob said:
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 said:
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
Click to expand...
Click to expand...
 
Top