Link query reult 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
 
I am trying to make a form which searches the fields i
select in the list box i have created.
It sounds like you have created a form that i am trying to
create.
I want my form to search a drawing number and keyword and
the results of that form i am trying to dispaly in a
subform (the query is in the subform).

I have created the interface form, but cannot link them.

I posted something earlier, this is it:

I need to link a list box in a form to the criteria box in
the query.
I have a list box in my form that shows the different
options that i want to put into the criteria box in the
query.
the query is loaded into my form in the instance of a
subform. When i click on one of the options in the list
box i want the query search to search for the name i
selected in the box.

Can you please help me.
If you would, could you please send me a sample of your
database so i could see your layout and coding.
Thankyou
 
Back
Top