FORM/SUBFORM EXIT SUB IF 0, HELP

[storyboy]

Is there a way to exit a subform based on a field control in the subform, such as, If the QTY is 0. I want to not save that entry of detail, and continue filling out the fields on main form. This is an invoice data entry situation that I am working on. I really like Access, but being new at it, I need help. Thank you in advance for your good help.
Tom

 

[GingerR]

Not quite sure I understand, but if you don't want people entering information of QTY = 0, you can put that kind of validation on the QTY control and prohibit users from entering 0 at all.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hermanlaksko]

You can refer to a subform like this:
Dim Frm As Form
Set Frm = Forms!YrMain!YrSub.Form
If Frm!Qty=0 then .....

Hope this will help you

Herman

They say that crime doesn't pay... does that mean my job is a crime?