Error checking query and message

[Jen0dorf]

Hi



have a query

SELECT tblDeceased.GraveID, tblDeceased.Mlink, tblDeceased.Plot, tblDeceased.GraveNo, tblDeceased.Forenames, tblDeceased.Surname, tblDeceased.Age, tblDeceased.YearOfDeath
FROM tblDeceased
WHERE (((tblDeceased.YearOfDeath) Like "*" & [Enter a Year Of Death]));[/CODE]

this works well but if someone inputs a letter rather than a number nothing comes ups in the related form.

To make it tidier thought it would be nice if a Message box came up saying - "only numbers are permitted"

research on the web found me this code snippet

Sub CheckError()


On Error GoTo Handler:

Exit Sub

Handler:

MsgBox ("Not a number")

End Sub

The above code is VBA

Is it possible to add error checking to a query design? or do I convert the query to VBA, if the latter is there an easy way to convert the query to VBA?

thanks

Ian

[orange]

How is YearOfDeath defined in your table? Number or Text?

[Jen0dorf]

Hi

good point ;-)

it's defined as text.

Gets a bit more complicated?

Ian

[NoellaG]

Hi,

can't you refer in the query to a field on a form (small dialogue form) and put an input mask on the form field allowing only numbers?

Kind regards
Noëlla