Create Cyclic Group from Listbox entries

[#1]

I have searched here and found nothing on this so far...

I am trying to find a way to create a cyclic group from the entries in a listbox.

There are only two entries in the listbox: 'Inpatient', 'Non-inpatient' and I want the user to be able to cycle a report on the screen through 'Inpatient', 'non-inpatient' and both.

I'm sure there's a trivial answer to this which I am missing, or a better alternative.

Thanks in advance.

Simon

[#2]

Hi,

If you can post a sample application of your requirement, it will be easy....

Regards

[#3]

Thanks for engaging.

I'd rather solve this without posting a sample, as I will have to reduce the dataset (it's a large model), randomise the data and probably a few other things that I don't have the time to do at the moment.

I have been fairly explicite with my question.

Thanks

Simon

[#4]

i dont think its a cyclic group you're after because 'inpatient' and 'non-inpatient' are values in the same field, a cyclic group would be if you wanted to cycle through the same data set but vieing by month, quarter, year and back again.

probably could do something with a button and a macro, each press of the button checks the current selections and then changes them in order, e.g. (> - represents the press of button)

'Inpatient' > 'non-inpatient' > 'inpatient' and 'non-inpatient > 'Inpatient'

i'm not sure how youd start that off but if you reword your question someone should be able to help.

[#5]

Hi,

Hope this will help...

Check the attached application

Regards,

Nilupa

[#6]

I think that helps

Thanks a lot.

Simon