Need Hyperlink Help.. Access 97

By sweiss06 ·
I am having trouble linking my table rows to a form by hyperlink. I'll give the layout to help clarify. I have a table let's say Company Jobs. The Table has Columns "Job#" "Date" and "Preformed by". I was hoping that i could create the "Job #" column in a hyperlink format. Then by clicking on this would upload the row into my form. Have been unsuccessful so far. Also am curious how i can make sure these hyperlinks are working properly when new records are created through the form. Any help on this issue would be greatly appreciated.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

A hyperlink might not work

by jesus h In reply to Need Hyperlink Help.. Acc ...

If it is a hyperlink, Then by clicking on this, it would open your default web browser and try to connect to that web page.

You might want to change the Job#'s data type from "hyperlink" to "text" or "number".
Then add another field "ID", data type "AutoNumber".

Then use the wizard to add a "Combo Box" to the form, to switch/find Job#s.
It might look as follows,
name: Combo8
Row source: SELECT DISTINCTROW [Company Jobs].[ID], [Company Jobs].[Job#] FROM [Company Jobs];

Sub Combo8_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Related Discussions

Related Forums