I'm having an issue with creating a new record. My problem is shown in the bitmap attached.
In short, when I attempt to add a new record, the strHotelName, and HotelID should still maintain the same information in it.
On the second form shown, it shows that when I proceed to add a new record, the BOMID is autonumber, which works out fine, but the strHotelName and HotelID are cleared out. Is there anyway to keep this value the same when creating a new record? IE, so that I can keep the information in the form consistent, as well as lock the fields?