I have a after update event on a combo box that does a dlookup to grab the person that is allocated to the area. Areas are allocated to a school which is related to a bookings table
using
it pulls in the person from the tblTourOrganiser table.BookerIDBonus = DLookup("TourOrganiserID", "tblTourOrganiser", "TourOrganiserID=" & TourOrganiserID)
BookerIDBonusName = DLookup("MergedNameT", "tblTourOrganiser", "TourOrganiserID=" & TourOrganiserID)
However.
If a school is allocated to an area but no person is allocated to an area yet then there is no id then for it to pull I get an error and runtime shutown (runtime just crashes on errors).
In access how would I get around this that if I ran into this rare problem it wouldn't crash. How can I get around this? Ask an "if null" ?