Add Record Button

[quig699]

This may be somethng easy but for the life of me I can't figure it out. Is there a way to set up a form to close automatically after the add record button is clicked?

Thanks for any help.

AMY

 

[Eupher]

Me.Close?

 

[TheAceMan1]

. . . or:

[blue]   DoCmd.Close acForm, "[purple][b]FormName[/b][/purple]"[/blue]

See Ya! . . . . . .

 

[quig699]

Where exactly would I put this code??

Amy

 

[TheAceMan1]

How are ya quig699 . . .

I answered the question with as much vagueness as you asked! . . . I'm sure [blue]Eupher[/blue] did as well!

If your saying after the [blue]AddNew button[/blue] is clicked you want to save the current record & then close the form, then the code we've presented here should be the last line.

If its anything else you need to be more specific! . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[Eupher]

AceMan answered vaguely, I answered incorrectly! Sorry, I haven't done much coding lately. Use it or lose it, ya know...

Ken S.