K
kikowillers
Hi! It's me again.
In one form I have a combo box and the row source for it is:
SELECT Companies.name_company FROM Companies UNION Select "HOLIDAY" a
Bogus From Companies UNION Select "NOT_AVAILABLE" as Bogus2 Fro
Companies ORDER BY Companies.name_company;
The combo box is ordered by "name_company", but I would like to sho
"HOLIDAY" and "NOT_AVALIABLE" at the end of the combo box.
(the field "name_company" is required)
OR
If it's not possible, can I hide "HOLIDAY" and "NOT_AVALIABLE" from th
combo box? Because I'll use them ONLY when I select a check box in th
form, that will set "name_company" as HOLIDAY OR NOT_AVAILABLE.(I hav
2 check boxes, one check box for HOLIDAY and one check box fo
NOT_AVAILABLE)(the field "name_company" is required)
Is it possible?? How can I do this???
I would really like some help. Thanks,
Kik
In one form I have a combo box and the row source for it is:
SELECT Companies.name_company FROM Companies UNION Select "HOLIDAY" a
Bogus From Companies UNION Select "NOT_AVAILABLE" as Bogus2 Fro
Companies ORDER BY Companies.name_company;
The combo box is ordered by "name_company", but I would like to sho
"HOLIDAY" and "NOT_AVALIABLE" at the end of the combo box.
(the field "name_company" is required)
OR
If it's not possible, can I hide "HOLIDAY" and "NOT_AVALIABLE" from th
combo box? Because I'll use them ONLY when I select a check box in th
form, that will set "name_company" as HOLIDAY OR NOT_AVAILABLE.(I hav
2 check boxes, one check box for HOLIDAY and one check box fo
NOT_AVAILABLE)(the field "name_company" is required)
Is it possible?? How can I do this???
I would really like some help. Thanks,
Kik