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

troy_lee@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.