adding new records

[Sztranyovszky Tamás]

Hello,

I have a command button on my form with this code in its OnClick event:

DoCmd.OpenForm frm, , , , acFormAdd

The form "frm" is a form bound to a table. The problem is - I want form "frm" to allow add only one new record!



Thanks

 

[Dan Artuso]

Hi,
This might work for you.
Remove the navigation buttons on your "frm" form.
You do that from it's property sheet.

Then place a "Save" button on the form with this code in the click event:

Me.Dirty = False
DoCmd.Close

This way the user will not be able to navigate to another new record and the form will
close after saving the "one" new record.

 

[Sztranyovszky Tamás]

Thank you! It is exactly what I need!



Sztranyovszky Tamás