Showing the next form and output message

[Brian C]

I've run a query from form1 that returns a field called
[Booking Id] from the AVAILABILITY table. I want to check
that it contains the numeric 1, link to form2 if it does
or output a message to form1 if it doesn't.

How do I do this: Can I have an if statement such as:

if AVAILABILITY![Booking Id] = 1 then
how do I link to form 2?
else
how do I output a message to form 1?
end if

Thanks

 

[Graham R Seach]

Brian,

I don't quite understand what you're trying to do. What do you mean when you
say you want to *link* to form2? Also, how do you want to *output* a message
to form1 - and what form are you currently on?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html