Hyperlink fields

[sc5502]

I want to try something but do not know to how to go about this. I have two tables in a one to many relationship (supplier and ratings). In the ratings query the field rating date is displayed. How can I make the rating date a hyperlink field and when clicked a rating form is displayed?
Attached is an example of what I want. Thanks in advance for your help.

[imgnothumb] http://bytes.com/attachment.php? attachmentid=78 13[/imgnothumb]

[imgnothumb]http://bytes.com/attachment.php? attachmentid=78 14[/imgnothumb]

[Seth Schrock]

Sorry, I can't open attachments at work, so I can't see your images. To do what you are wanting, you need to have a form based on your Ratings query. The query would also need to have the primary key field included. You would then have a textbox bound to the Rating Date field. In that textbox, change the Is Hyperlink property to Yes (found in the Format tab of the property sheet). You would then need to add the following code to its On_Click event.

DoCmd.OpenForm FormName:"yourRatingFormNameHere", _
               WhereCondition:"PKFieldName = " & Me.PKFieldName

Just change the name of your form and the primary key field name to match what you have.

[sc5502]

That is great. Thank you.

[Seth Schrock]

Glad to be able to help.