By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 1,077 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Hyperlink or command button

P: n/a
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
Sep 6 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Sep 6 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.