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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Undo if same record exists 4
Copy previous record into form field 0
Determine if a record exists 8
Passing a value from subform or main form to subform query 4
Append Records from a subform to a new record 1
If record exists, edit it? 2
Enter Parameter Values Problem 1

Top