combobox in a form based on a table 1

[yellowke]

Hi,

Is it possible to use a combobox with a control source e.g. u218sub8.worktime and give the user only 2 possibilities to choose from e.g. partime and fulltime

So the combo box is based on an element from a table, but In that element of the table are only 2 possibilities allowed. I want to do this so the user can't type anything wrong in that element when they edit or add a record via the form.

Thanx guys
Yellowke

 

[ramani]

HI
This is possible..

Set the following properties for the combo box..

RowSourceType = 1
RowSource = "PartTime,FullTime"
ControlSource = "u218sub8.worktime"
FirstElement = 1

And then suitably add in your validation place.. that some value is surely selected and that the user has not skiped this combo OR did not choose any value at all.

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Happy New Year

 

[yellowke]

It works

Thank you Ramani