Linking cell information from query result to form problem???

[Leover]

Hello,

First of all Thanks to Hymn and Parkroyal for the reply to my earlier post but I think I wasn't very clear about the whole dilemna that is my database.

To Parkroyal and Hymn thanks and the subform idea, it will come in handy later on for a different application in the database.

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 following categories. 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

Leover

PS: Sorry for long email

 

[Leover]

Hi chaz,

Sorry to bother you mate, but I am a little stuck,

I want to be able to open that MPS Form and edit it. But when I try and open the MPS form it keeps refering to the other query. Like it will only open if you use the search form.

This is what i did. I made another form called Edit MPS FORM and on it I have a Text box named project number. I also have a button on the form with a macro controlling it.

I have made a query that I use as a filter so that it oly looks for the exact project number that is entered into the project number field in the Edit MPS FORM.

My Macro on the Edit MPS FORM has the following in it..

OPEN FORM
Form Name>>> MPS FORM (this is the main form I want to open)
Filter Name>>> edit mps query (the query which is used to match the project number in the Edit MPS FORM )

GOTORECORD
Object Type >>> Form
Object Name>>>MPS FORM
Record>>>>>>>Go To

When I try to run this message appears asking for parameter values from the RESULTS FROM SEARCH query.

Any suggestions

Cheers

Leover

 

[Blorf]

Will look into it and get back to you.

ChaZ

Ascii dumb question, get a dumb Ansi