Row Source Problem

[hgg21]

Hi all,

I have a combo box which is supposed to display a particular field from a table. There are many duplicates info in this field. Eg Shift1, Shift2, Shift3, Leave, MC.
However, I only want it to display Shift1, Shift2 and Shift3.

How do I write the row source statement?

Select Distinct "Shift1" from Activity
But I cant add in Shift2 and Shift3.

Pls kindly assist. Thks.
Jerry

 

[adamroof]

Choose the 3 dots next to Row Source on the Data tab of the properties on that combo. In the query that pops up select the rows that you want into the combo. In the Criteria section add Shift1, in the OR add Shift2, next OR add Shift3.

If the shifts are seperate rows, in the Format Tab, set the Column Count to 3 or 4 and the Column Widths set them to 0";1";1";1" (if you have a ShiftID you dont want to show)

Hope thats what you mean!

 

[hgg21]

Hi Adamroof,

Thank you for ur help.