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, ...