Recent content by harrym

on the form frmReservations i have all this fields from the table, and on celular field the dlookup.

table has the followin fields reservationID, celular, names, date, hour, adults, kids, comments, arrival hour, noshow.

I would like if there was never a noshow the report does not open, only if there was a noshow the report should open. from the celular number entry.

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

Run-time error 438 Object doesn't suppoort this property or method

Gives me an debug error

Opening the form I got the Cash Entering some records in the subform nothing changes on the unbound field.

Excuse me it is the unbound txt13.

Hi Have tried all this Forms!frmCashBook!txt13.requery Forms!Mainform!txt13.requery Me.Parent.Parent!txt13.requery Me.Parent!txt13.requery Forms!frmCashBook!frmSubCashBook.Form!txt13.requery but not working To explain u some details Txt13 is an unbound field on the Mainform...

I have a form CashBook with the subform subCashBook On the mainform i have a textfield to get the actual cash amount I programed CashDate on the mainform with setfocus to get the exact amount from the tblCashBook. I tried everything to change the textbox with the new amount after entering paid...