Controls on an access form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know this is probably simple but I am going crazy trying to figure it out:
I have made a form based on an access table. I have a combo box so that
others can find the record they need to update etc. The combo box is based on
a field in the table that contains hyperlinked information. I do not want the
hyperlink info to be activated in the form because then anytime you search
for a record and enter it also activates the link instead of just bringing up
the record.

Does this make sense? Help! Thanks
 
I think you are doing the same thing I am in a way. I have a combo box that
is doing nothing but finding and selecting records.

I set the cntrol cource to the table containing the records I want to search
through.
For row source I select the key column and any others that will help
identify the record. Then goto the event tab and select afterupdate and try
the below code. I tried it with a hyper linked field and it worked without
activating anything. The only thing to remember is you have to search with
the key column.

Private Sub Combo20_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[key] = " & Str(Nz(Me![Combo20], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
 
Back
Top