please help on the form

[SJJ via AccessMonster.com]

i have a form, with in the form i have three sub forms. each subfom contain
the fields given below

date: 03/02/2005
time :Evening

lots of them..

it can contain same date with different times but it cant contain same date
and same time twice. however i have a field called searchDate and searchTime
on that form. if i enter some date and time on those fields and click
"Search" button it should show whether the provided date and time already
exists on any of those subforms. may be a message says "the date and time
already booked out".

is it possible to do that in a form

thanks in advance.

 

[Guest]

Create a query that have the seach entry textboxes as criteria. Build a
macro with condition DCount("[ID]","Query1")>0 and action MsgBox.
Substitue your query for Query1 and an output field of your query fo ID in
the above condition.
Type you message in the pane at the bottom of the window.

 

[SJJ via AccessMonster.com]

sorry but i dont understand the solution. could u be able to explain in more
detail if possible please.

thank you