Link cell from query result to form???

  • Thread starter Thread starter Leo
  • Start date Start date
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
 
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.
Click to expand...


Don't open the query datasheet *AT ALL*, and don't "run" the query!

Instead, create another Form, using the query as its Recordsource; and
put a button on your unbound search form to open the bound
data-display form.

Also: if you wish to post the same question in several newsgroups,
please crosspost by putting the newsgroup names (no more than two or
three please!) in the Newsgroups line, rather than multiposting. This
will let volunteers note which questions have already been answered.
 
Back
Top