Further new user questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I think I may be repeating myself from my response in my earlier post, but
I'm getting a bit stumped. I'll understand if people don't want to answer my
questions since they may be somewhat elementary, but I'm still trying to
figure these ones out. For one thing, every time I open my form, it keeps
automatically populating my fields with whatever happened to be in the most
recent row entered in the table instead of being blank so my users may enter
new information. What am I doing wrong?

Also, any way to have them be able to click on a button to save the data
they entered, then automatically go back to a blank form and being able to
then exit the form without being told they have to enter data because the
form thinks they are trying to add another record? Will Access do this?
Again, my apologies if my questions are all beginner stuff, but I am a
beginner with forms and am having trouble for now. Also, my apologies,
because I think I may be basically repeating myself from my response to my
own earlier post.
 
Paul,

Access always opens bound forms with the first record in the sort order
showing. It is possible to make it appear to open to a new record. In the
Open event of the form:

DoCmd.GoToRecord acDataForm, "MyFormName", acNewRec

If want to use a Save button and have a blank record showing when it is
clicked, use the same line above in the click event of the Save command
button.

To avoid the message you get when you want to close the form, you can set
warnings off. It can be done in code in the Open event of the form:

DoCmd.SetWarnings False

Hope this helps.
 
Back
Top