Form Button to change rowsource

[MARKYB0Y]

Hi,

I have a continuous form with 30 records that is too long really so I would like to split it into 2 lots of 15.

I have created 2 query's that select the 2 sets of 15 records.

how can I create a button to change the rowsource to the other query so the other set of info gets loaded into the form?

alternatively I suppose I could have 2 forms, in which case how would I set one button to not only open the other form, but also close the current form?

I am running Access 2007

thanks in advance

 

[KenHigg]

me.recordsource = "myQueryName