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
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