adding new records

  • Thread starter Thread starter =?ISO-8859-1?Q?Sztranyovszky_Tam=E1s?=
  • Start date Start date
?

=?ISO-8859-1?Q?Sztranyovszky_Tam=E1s?=

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
 
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.
 
Thank you! It is exactly what I need!



Sztranyovszky Tamás
 
Back
Top