form going blank

[bluesage]

hi

i created a form. added a group of option buttons and then i set the forms record source to have a source of 1 table and 10 queries.

SELECT * FROM tblname, query1 ... query 10

when i viewed the form in form view, it was blank ? can anyone help me? if i remove the record source, i can view the buttons an all.

each query i have made, selects a distince person from a table, and is used as a label to the option button, so when i change the names in my tables it will automatically change the names on the labels.

thanks

 

[PHV]

SELECT * FROM tblname, query1 ... query 10
Have you tested this SQL in the Query builder to test how long it takes to complete ?
Seems like a cartesian product ...

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884