In code stop a form from allowing new records to occur

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to able to stop records from being able to be created based off a
certain criteria. I tried setting the .allowaddition function to false but
that did not work. I am in the main form and entering the subform. The
subform is the form that I want to disable allow additions. Here is the code
I was using:

With [Forms]![Main]![BidInfo]
..AlllowAdditions = False
end with

but this was not working. I am sure I do not have the right syntax but I
can't seem to figure out what it is. Any help would be greatly appreciated.

Thanks in advance,
John
 
John,

Try it like this...
Me.BidInfo.Form.AllowAdditions = False

What event are you using this on?
 
Back
Top