tr******@comcast.net wrote:
I have a continuous form. One of the fields shown is the Primary Key.
I want to be able for users to either:
Click on the ID number and be taken to that record which is in another
database
or
Click a "View Record" command button and be taken that record in
another database.
Which is the better approach and how to implement?
Thanks in advance.
Troy
I suppose you mean "another table" instead of database.
What I might have is a function called ViewRecord that will open the
form to display the other record. It returns a boolean True.
Then, in design mode, I'll highlight/select all fields the detail row
and pull up the property sheet, click into the OnDblClick event, and enter
=ViewRecord()
Then create a command button with View Record as the caption and enter
Dim blnView as boolean
If Me.Recordsetclone.Recordcount 0 then blnView = ViewRecord()
in the OnClick event.