Solved

How hide #Error in a form field

Posted on 2016-11-26
2
23 Views
Last Modified: 2016-11-26
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
Comment
Question by:SteveL13
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 41902414
try using the NZ() function

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

Author Closing Comment

by:SteveL13
ID: 41902434
That did it.  Thank you.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question