Dynamic form creation

[rik]

hi,

i have a database with 15 queries that are all manipulations of the same few fields.

do i need to create a seperate form for each query, or can i develop one form that dynamically imports data depending on the query (possibly through a main form with option buttons).

thanks
rik.

 

[ajetrumpet]

Rik,

I bet that you could use the form's recordsource property to do this. Say like, having query choices on the main form represented by "yes/no" controls, and opening the "universal" form based on the control that checked.

 

[rik]

thanks... i went with the docmd.openform way!