I have a form for reservation and like to put an dlookup for noShows
I have done this
Private Sub Celular_AfterUpdate()
If (Not IsNull(DLookup("[Celular]", "tblReservations", "[Celular] ='" & Me!Celular & "'"))) Then
DoCmd.OpenReport "rptReservationsNoShow", acViewPreview, , "Celular = '" & Me!Celular & "'"
Else
End If
End Sub
But this works for all reservations which already have some times ago an reservation with the same celPhone number on my tblReservations data base.
Like to get the openReport only for reservation which have "no" in the table text field Show.
I have done this
Private Sub Celular_AfterUpdate()
If (Not IsNull(DLookup("[Celular]", "tblReservations", "[Celular] ='" & Me!Celular & "'"))) Then
DoCmd.OpenReport "rptReservationsNoShow", acViewPreview, , "Celular = '" & Me!Celular & "'"
Else
End If
End Sub
But this works for all reservations which already have some times ago an reservation with the same celPhone number on my tblReservations data base.
Like to get the openReport only for reservation which have "no" in the table text field Show.