M
Manoli
OK, this is a bit complicated so I will try to simplify as best as
possible:
Unbound Form with one list box based on a query which returns two columns:
based on table: t_popup
Report Name
K_report (primary key)
I have set up another query to return four columns:
based on tables: t_popup equi-joined to t_data_fields_search
Report Name,
Report Sample (hyperlink text)
k_report (which is the primary key on the table where the report sample
is)
K_REPORT (which references same table as list box)
I would like to set up a command button that the user will open (and
possibly execute) the hyperlink.
I'd also like to set up a command button that will open the form f_1_general
based on k_report id selected.
I'm not sure of the code needed to get there. I keep getting an Active X
error which makes me feel I'm way off.
Any thoughts?
Thanks all!
possible:
Unbound Form with one list box based on a query which returns two columns:
based on table: t_popup
Report Name
K_report (primary key)
I have set up another query to return four columns:
based on tables: t_popup equi-joined to t_data_fields_search
Report Name,
Report Sample (hyperlink text)
k_report (which is the primary key on the table where the report sample
is)
K_REPORT (which references same table as list box)
I would like to set up a command button that the user will open (and
possibly execute) the hyperlink.
I'd also like to set up a command button that will open the form f_1_general
based on k_report id selected.
I'm not sure of the code needed to get there. I keep getting an Active X
error which makes me feel I'm way off.
Any thoughts?
Thanks all!