Showing the next form and output message

  • Thread starter Thread starter Brian C
  • Start date Start date
B

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
 
Back
Top