A
Andy12
Yo,
Alright I will explain my situation, I work in a concrete company, and we do
a lot of service afterwards. So I have designed a database to track service.
In my database I have a form for each lot and in this form I have tab
control. In the one of the tabs I have another form viewed in a spreadsheet
to show multiple services for just that lot. What I want to do is be able to
DblClick on a feild in the spreadsheet form and open another form with that
specific record.
What I have done so far is created a macro with action open form. And on
the properties of one of the feilds in the spreadsheet form, I applied the
macro to the DblClick event. The macro works itself but, only opens the form
to the first record in that table. I want to open that form with that exact
record some sort of link. I think I have to use the Where condition in the
macro but every expression I used doesn't work. DOES ANYBODY HAVE ANY
SUGGESTIONS?? PLEASE!
Thanks
Alright I will explain my situation, I work in a concrete company, and we do
a lot of service afterwards. So I have designed a database to track service.
In my database I have a form for each lot and in this form I have tab
control. In the one of the tabs I have another form viewed in a spreadsheet
to show multiple services for just that lot. What I want to do is be able to
DblClick on a feild in the spreadsheet form and open another form with that
specific record.
What I have done so far is created a macro with action open form. And on
the properties of one of the feilds in the spreadsheet form, I applied the
macro to the DblClick event. The macro works itself but, only opens the form
to the first record in that table. I want to open that form with that exact
record some sort of link. I think I have to use the Where condition in the
macro but every expression I used doesn't work. DOES ANYBODY HAVE ANY
SUGGESTIONS?? PLEASE!
Thanks