Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft: Access Other topics FAQ

Access Howto:

How do I create a form that opens on a new record but allows edits? by Quehay
Posted: 8 Dec 00

To have a data entry form that lets users start entering records but also easily go to existing records for editing do the following:

(This works only for forms that have a combo or listbox to look up and go to existing records.  The wizard will do it, just select "find a record in my form. . .".)

Set the DataEntry property for the form to true/yes in the data section.

In the AfterUpdate event of the combo or listbox there will be wizard generated code to the effect of:

Dim rs as object

     Set rs = me.recordset.clone

Before the Set statement put in the following line of code (you'll get an error if it comes after the Set statement):

Me.DataEntry = False  

The form will go to an existing record when a selection is made in the list or combo and the navigation controls will be enabled (and show "Record _ of ___" for the total in the table).

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close