Link query result back to form ???
Leo
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
Steve Schapel
In normal database usage, you would not normally directly use or see a
query datasheet. I think all you need to do is make a form based on the
query which you now have, i.e. this query will be the record source of
the form. And then, whatever you are currently doing to open the query
datasheet, open the form instead.
--
Steve Schapel, Microsoft Access MVP