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

Undo if same record exists 4
Append Records from a subform to a new record 1
Enter Parameter Values Problem 1
Passing a value from subform or main form to subform query 4
Count subform records where txtCount = 0 1
If record exists, edit it? 2
subform to main form formula #Error 2
Locked Subform still lets me delete a record 2

Top