Two comboboxes based in one field?

[Kyriakos]

Hi, this is the situation. I have one table with some fields in it and based on this I want to design a form.

On this form I want 2 combo boxes to do thisne to set a starting point for a field and another one to set the finishing point. Something like From this value to the other value, and everything else from the table to be diplayed based on the selection...

How am I able to do this?

Thanks
Kyriakos

 

[namliam]

You should probably split the column into two fields...

but....

It should be possible if you use some smart coding and stuff, but it would be a headache IMHO...

Physicaly spliting the column into 2 and merging the 2 columns when needed in reporting and such or where ever needed would be the way to go...