I suspect this is what the original poster was looking for, though, "link it
to the database" is not very precise and specific. I would comment that
using a continuous-forms view form for selection is a useful approach for
modest amounts of data, and for applications running on a single machine, or
over a high-speed LAN.
It can be problematic over a LAN or WAN, with large amounts of data.
When I have done this, I haven't forced my users to click on a particular
Control in the Row, but gotten to the same code when anything in the Row,
even outside Controls, is double-clicked.
If you are not allowing editing, but only selection, on the continuous-view
form, you can very easily accomplish this by creating a Command Button,
sizing it to cover the entire Detail Section of the continuous-view Form,
and setting its Transparent Property to Yes, with the code/macro to open the
"detail form" in the Command Button's Click or Double-Click property.
If you want to allow editing of the Controls on the continuous-view form,
you can create the code function in the General section of the module, and
just reference it in the Double-Click event of each Control, and in the
Form's Detail Section events, too.
Larry Linson
Microsoft Access MVP
AKphidelt said:
Hey Pinky, i sort of have the same thing going on in my program. Im not
experienced enough to link it to the actual master list... so what I did
was
created a separate form that has a recordsource to the master table and
used
this code. Theres probably easiar ways around it but this was my way
through
trial and error.
Private Sub Form_Load()
Dim rst As DAO.Recordset
Dim Response As String
Response = Forms![tabIncident]![tabReport Number]
Set rst = Forms![FullIncident].RecordsetClone
rst.FindFirst ("[ReportNumber] =" & Response)
If rst.NoMatch Then
MsgBox ("No match found of that record")
Else
End If
Forms![FullIncident].Bookmark = rst.Bookmark
End Sub
The way this works is that each incident has a unique report number to
it...
so the find first method finds that record... if you search with multiple
records that can have the same value then I can't help you with that.
Let me know if this is sort of what you want.
pinky said:
I have a database we use for logging incident tickets, however we have a
button that opens up all OPEN non resolved incidents, is there a way that
when I open this I can double click on the incident and link it to the
database? Please help I'm new at this?
