before insert event

[hunterfan48]

where do I find this in my property setting?

thanks a bunch!

 

[vbaInet]

It's in the Property Sheet. Right click your form in Design View and look iin the EVENT tab.

See attached where to click.

 

[John Big Booty]

You will find the Before Insert event in the Form's Event tab.

You will know you have the Form's Properties when the Small square at the junction of the vertical and horizontal rulers has a small black square in it (when the form is in design view)

 

[hunterfan48]

if i'm tryin to do something with the subform, I would select the subform and then if I'm referring to before, I would enter it in the 'on enter' section of the event tab right?

Also, how would I use an expression builder to insert a new record. That's what I'm trying to do...is there a function in that? I wouldn't know how to do it with code so I figure expression builder is easiest. thanks