[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 38
  • Last Modified:

How hide #Error in a form field

I have this as the control source but am getting #Error if cboVehicleUsedID hasn't been selected from a combobox.

=DMax("[CurrentMeterRead]","tblDaySheets","[VehicleUsedID] = " & [Forms]![frmDaySheet]![cboVehicleUsedID])

How can I hide the #Error ???
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try using the NZ() function

=DMax("[CurrentMeterRead]","tblDaySheets","[VehicleUsedID] = " & nz([Forms]![frmDaySheet]![cboVehicleUsedID],0))
0
 
SteveL13Author Commented:
That did it.  Thank you.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now