Help with a combo box in a form

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top