Unbound Combo Box Quiery

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
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.
 
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.
 
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
 
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
 
Back
Top