If statment Help

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

On my form i have a button that when it gets pressed it adds data to
the subform. the code works fine

I just want a if statment that will stop the code working if data
alredy existes in the subform.

If data exists i want a error message, if ther is no data let the code
run


Im not sure how to code it for it to see if there is data in the
subform


Any help will be great


Simon
 
Hopefully you've got a KEY field in the subform, an identifying field, a
primary key???

if you have then use code like

if isnull(Subform.Form.Primarykeyfield) then

you have no records

the Subform and Primarykeyfield need to be changed to be your apps names.
eg, InvoiceLines.Form.InvoiceNo
 
You must log in or register to reply here.

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

If statments 1
DELETE FROM a table WHERE... 1
Subform Data Entry Setting 0
Parameter Value error in a Subform 0
Updating tables when you input new data 0
Remember the Date 4
Date button to a Subform 2
Sometimes GotFocus event doesnt occur on subform...strange 1

Back
Top