Custom Message when records are null

[Digital Carnage]

Hi Folks,
I have a tabbed form that allows you to interact with Employees, Add
Vehicles & Edit Vehicles. Employees can exist in the database without
having vehicles so I'd like to create a custom message that replaces an
otherwise blank looking form when records do not exist. Some kind of
message like "There are currently no vehicles registered to this employee,
to add a vehicle please select the "Add Vehicle" tab from your menu"! How
do I do this and where to I place the code? TIA, Rich

 

[Wayne Morgan]

In the form's OnCurrent event, check the value of the field you are interested in and use
a MsgBox to show the message. The OnCurrent event fires every time you move to a different
record on the form.