L
Leo
Hello,
The problem I am facing is this,
I have made this search form which seaches my data base
for a project number and project type. This search form is
linked to a query which seraches the above mentioned
fields. This works excellent and is really cool.
What I am trying to do now is link the results from the
query to there corresponding form. When the results from
the query appears, it is in Datasheet view with the
different project numbers and projet types that fit the
search criteria along with some of the other fields.
When the query table appears I would like to be able to
click on the project number and view the details of the
project which is in a form.
I am stuck because I don't know how to link the project
number in each individual cell to its corresponding form.
I've tried making a macro but there are no commands that
can link the cell to the forms? Or is there?? To make it
worse my ability to write modules is about as good as
India's cricket teams fielding abilities. I'm terrible at
writing VB modules in fact any form of code.
If anyone has done anything similar I would like to hear
about how you attacked the problem.
Cheers
Leo
PS: Sorry for long posting
The problem I am facing is this,
I have made this search form which seaches my data base
for a project number and project type. This search form is
linked to a query which seraches the above mentioned
fields. This works excellent and is really cool.
What I am trying to do now is link the results from the
query to there corresponding form. When the results from
the query appears, it is in Datasheet view with the
different project numbers and projet types that fit the
search criteria along with some of the other fields.
When the query table appears I would like to be able to
click on the project number and view the details of the
project which is in a form.
I am stuck because I don't know how to link the project
number in each individual cell to its corresponding form.
I've tried making a macro but there are no commands that
can link the cell to the forms? Or is there?? To make it
worse my ability to write modules is about as good as
India's cricket teams fielding abilities. I'm terrible at
writing VB modules in fact any form of code.
If anyone has done anything similar I would like to hear
about how you attacked the problem.
Cheers
Leo
PS: Sorry for long posting