open form action cancelled

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two forms.

The first one has few search boxes and on click the search button it
displays (requeries the "unique query")
after which the user from the short list on the form can click on the view
form (which opens another form with various details)

It works fine except in two cases...

1) if some fields in the 2nd form (query) are blank .. or 0 , a MSG box
popsup saying " OPEN FORM ACTION WAS CANCELLED"

How can I work around this and still display the results?

2) sometimes there are no records in the 2nd form to display. Instead of
displaying a blank form , how can I put a msgbox saying "NO DATA found"

any help / advice appreciated
 
flow23 said:
I have two forms.

The first one has few search boxes and on click the search button it
displays (requeries the "unique query")
after which the user from the short list on the form can click on the
view
form (which opens another form with various details)

It works fine except in two cases...

1) if some fields in the 2nd form (query) are blank .. or 0 , a MSG box
popsup saying " OPEN FORM ACTION WAS CANCELLED"

How can I work around this and still display the results?

2) sometimes there are no records in the 2nd form to display. Instead of
displaying a blank form , how can I put a msgbox saying "NO DATA found"

any help / advice appreciated
Click to expand...
 
Back
Top