Timing Problem?

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

Forms![MakeTravelRequest]![frmCarRental]![cboCarPickup] =
Forms![MakeTravelRequest]![cboToAirport]
Forms![MakeTravelRequest]![frmCarRental]![cboCarReturn] =
Forms![MakeTravelRequest]![cboToAirport]
Forms![MakeTravelRequest]![frmCarRental]![CarReturnLoc] =
Forms![MakeTravelRequest]![cboToAirport]
Forms![MakeTravelRequest]![frmCarRental]![CarPickupLoc] =
Forms![MakeTravelRequest]![cboToAirport]
Forms![MakeTravelRequest]![frmCarRental]![CarDateOut] =
Forms![MakeTravelRequest]![TravelDate]
Forms![MakeTravelRequest]![frmCarRental]![CarDateIn] =
Forms![MakeTravelRequest]![ReturnDate]

Forms![MakeTravelRequest]![frmHotels]![HotelDateIn] =
Forms![MakeTravelRequest]![TravelDate]
Forms![MakeTravelRequest]![frmHotels]![HotelDateOut] =
Forms![MakeTravelRequest]![ReturnDate]

Me.Form.Dirty = False

Exit_SaveSelectedFlts_Click:
Exit Sub
---------------------------------------
When the coding above has a breakpoint on the first line, everything works
fine. However, when I remove the breakpoint, I get a message "The data has
been changed".

Can someone suggest what may be the problem here?

Thanks,
Bernie
 
Hi,


Start with a Me.Undo or with a Me.Dirty=false to undo, or save, any
modification YOU have previously done and not yet committed. Your VBA code
is ANOTHER user than you, at the keyboard, and you are both fighting about
who will change the value in a control, if one of YOUR modification is
pending. Saving or undoing YOUR modifications should solve the conflict.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top