Multiple selections

[eddcole]

Good afternoon all,

I wonder if someone can help me.

I am putting a scheduler together and dependant on the week selected and the frequency selected I would like certain week numbers checked.

Foe example if I pick week 2 and I put half yearly then week 2 and 28 would check or if I pick week 3 and pick monthly then week 7, 11 etc. would check

Thanks in advance

 

[arnelgp]

again please, dont follow.

or, you can create another table with possible combination:

fields:
weekNo (number)
frequency (string same data you have in your combo)
Weeks (string, csv of weeks you want to return)

you can also use this table as your rowsource for you combos.

then we can just query this table to give us the results, or manipulate the results in anyway we want.

 

[eddcole]

ok I have got a query to show the results I needed now how can I use the results to update the checkboxes on the form.

The results in the query are all checkboxes I would like this to be reflected in the form.

On another note I have tried to compile a report from the query (query has 54 columns) the report will only display 15 columns.

Cheers