i designed a data entry form for my database and i added a
command button to save records, how do i get it to reset
the form after its saves the record
You'll have to give us some more help here, Mike. Normally no button
and no code is needed on a data entry form; are you going around
Access' default behavior? Is this an unbound form and you're using VBA
code to write data to the tables? Or a bound form (in which case you
really don't need the button)?
It may be that all you need is a line
DoCmd.GoToRecord acForm, Me.Name, acNewRecord
Please post the code in your Save button and explain, if this doesn't
help.
John W. Vinson[MVP]
