View Full Version : Problem with opening of SPECIFIC Record


popen
01-22-2002, 01:18 AM
Hi all.
OK, I have a search form that pops up as a Dialogue box, you enter the criteria (GMC Number), and click on the 'Search Button'.

I have coding in place to account for if no record is found at this stage.

IF a record is found matching the criteria, another form (Results) opens with initial details of the record (Name, etc.)
The Results form has a query as the Record Source That pulls the details from the main table. The GMC Field in this query is dependant upon the value in the original SEARCH form.
No problems with this so far!
Here's the problem..................
On the Results screen, I need a facility(Command Button, Hyperlink) to OPEN yet another Form that will contain ALL the details of the record originally found. I have the form in place, it works fine for Input, BUT I need to open this form to display ONLY the specific record shown on the results form. I have tried various methods, but each time the form opens blank, as if I am adding a new record!
Can anyone help?
Thanks in advance

Fizzio
01-22-2002, 03:13 AM
Set up a query for the full form to be based upon and set the recordsource to that query. In the GMC field, set the criteria to
=Forms!ResultsForm!GMCNumber. When you open the form, it should only show 1 record equal to that of the GMC field in your original form.
HTH