I have a form ,with a table ,which have 12 column and 10 rows
i m set all these s hyperlink as view detailed report on same format and leyout
my problem is
"how can i set parameter for query ,which genrete report for one hyperlink(Cel1 A1), also run on click on cell B1, but changed parameter B in place of A
or can i use text box or label name as query parameter (not Value of text box or label or combo box)"
so i m beginner for access, vb and sql , so pls help me in simple steps and if possible with examples or pic
Thanks to all in advance
ootkhopdi
i m set all these s hyperlink as view detailed report on same format and leyout
my problem is
"how can i set parameter for query ,which genrete report for one hyperlink(Cel1 A1), also run on click on cell B1, but changed parameter B in place of A
or can i use text box or label name as query parameter (not Value of text box or label or combo box)"
so i m beginner for access, vb and sql , so pls help me in simple steps and if possible with examples or pic
Thanks to all in advance
ootkhopdi