Help with get current record on different ids... (1 Viewer)

[haavar]

I need help to get current record with different ids:

Dim strDocName As String
Dim strWhere As String
    strDocName = "16kanaler"
    strWhere = "[skjema_16_gr1_ID]=" & Me!skjema_16_gr1_ID
    DoCmd.OpenReport strDocName, acViewPreview, , strWhere

How can I use more Ids in the wherecondition? I want to get the current record for skjema_16_gr1_ID and skjema_16_gr2_ID, not only the first.

Please help me...

Håvar

 

[Bobadopolis]

I think something like:

strWhere = "[skjema_16_gr1_ID] =  " & Me!skjema_16_gr1_ID & " And [skjema_16_gr2_ID] = " & Me!skjema_16_gr2_ID

Bobadopolis

 

[haavar]

Thanks...

Thanks for help! It worked!