Re: how to create a query to handle "No Such Data Found"
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Mon, 11 Jun 2007 08:57:42 -0700
On Mon, 11 Jun 2007 04:59:15 -0700, Fuzuy wrote:
I try to create an interface to display records/ or posting message on
a form when I select data from a table which meet the combo box
values to diaplay on a form, however, sometime data of combination of
two combo boxes are not exist..
how should I do so that when it has data it displays the data on a
Form, while no criteria meets then it posts a message "No Such Data
Found" and be also direct back to combo boxes menu.
Thanks in advance for your help..
The form that displays the data is the form with the combo box?
Code the form's Load event:
If Me.RecordsetClone.RecordCount = 0 then
MsgBox "No Records Found"
Me.ComboName.SetFocus
End If
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
- References:
- Prev by Date: Re: Query in a form
- Next by Date: Re: how to create a query to handle "No Such Data Found"
- Previous by thread: how to create a query to handle "No Such Data Found"
- Next by thread: Re: how to create a query to handle "No Such Data Found"
- Index(es):
Relevant Pages
|
