Form with Filter, Data Not Found, Form Empty

  • Thread starter Robert Nusz @ DPS
  • Start date
R

Robert Nusz @ DPS

I have a problem and would like some advice. I have an input form named:
Fr_Search_By_Case which has an unbound text field named: Text_CASE_NUM_01.
This field has the FORMAT property set to @@-@@@@@@ and INPUT property set to
00-000000. The same form, has the AFTER UPDATE property set to perform a
macro named: Select_By_Case.

Macro: Select_By_Case is as follows:

ACTION = OpenForm
Form Name = Fr_CR_U
View = Form
Filter Name = null
Where Condition = [Fr_Case_DB2U_Srtd]![TST_FR_CASE_RECORDS.CASE_NUM]=
[Forms]![Fr_Search_By_Case]![Text_Case_Num_01]
Data Mode = null
View = Normal

------------------------

Problem is this. When user enters a Case record value, that a match is
found in the Queried table
[Fr_Case_DB2U_Srtd]![TST_FR_CASE_RECORDS.CASE_NUM], the form Fr_CR_U displays
the correct data.

BUT !!!!

When the user enters a value where record is NOT FOUND, the form Fr_CR_U
opens, but reflects NO TEXT fields, and NO DATA. Is there a way to condition
code some logic into this to the point that on a no match record found,
displays a different form, but if data found, displays the proper form
Fr_CR_U.

If anyone has some logic for this, I'd appreciate an example or help.

Thanks In Advance.

Robert Nusz,
DPS, State of Oklahoma
 
Top