Next empty line

  • Thread starter Thread starter Dennis Schmidt
  • Start date Start date
D

Dennis Schmidt

Hi DW,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You can set the form's Data Entry property to yes and the form will always
open to a new record. However, when you set it with this property, you
will not be able to display records entered before you opened the form.

You can also write a little code on the Form's OnOpen event that goes to a
new record. This method would allow you to see the previously entered
records. The code would look like:

DoCmd.RunCommand acCmdRecordsGoToNew

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Is there a way when you open a form to go to the next empty line in the
database and start.
thanks
 
Back
Top