Use record selecter on query to open a form 2

[TommyTea]

A few years ago, I found a small application containing Access tips. It showed a form with a grid view of tip categories. You could click the record selector (on the left of each record) and a form would open with the information about that subject. Does anyone out there know how this works? I think that this could be a great solution to something that I am working on now.

 

[KyleS]

Probably something like this:

Private Sub Detail_DblClick(Cancel As Integer)
    Dim strFormName As String
    strFormName = "The Name Of  Your Form Goes Here"
    DoCmd.OpenForm strFormName, , , "Put your where clause here"
End Sub

Where you replace "Put your where clause here" with something to filter the form you're oprning, ie

"[FormIDField] = " & me!txtLinkIDField

Kyle

 

[TheAceMan1]

[blue]You could [purple]click the record selector[/purple] (on the left of each record) and a form would open with the information about that subject.[/blue]

Have a look at the forms [blue]On Click[/blue] or [blue]On Dbl Click[/blue] events! . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: