IF RECORD EXISTS - records showing on subform (don't want to)

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

I have a main data entry form that contains a subform. Main form is
Header that contains all customer information, etc. The subform is a
Invoice detail (one or more rows).

Anyhow, I have a DCount script that checks if the InvoiceNumber
already exists. If so it'll show a text box "This number already
exists".

This works fine; however, if the end user enters a Invoice Number that
already exists it'll work as described above, but the detail records
from the already existing form pull up or show and I don't want that
to happen.

Could someone explain to me how to stop this? Thanks.
 
Back
Top