Automatic duplication of form when pressing ENTER

[tanveerksingh]

Hi everyone,

I am brand new to Microsoft Access so I have close to zero knowledge about the program. I just recently figured out how to create a form. My form has 5 fields (ex. name, date, etc.) and one has a drop-down list associated with it. I am conducting research and I need to basically create a series of forms to log information for each research participant (one form per person). Previously, this log was created by someone else and they were able to get the form to duplicate when pressing enter. In other words, when a form has been completed and one presses enter, a new (blank) form appears to input information for the next research participant.

This all sounds complicated, but I basically just need two things:


1. The form must duplicate (blank one appears) when ENTER is pressed
2. The forms are displayed in a "list" view rather than having to push the arrow buttons to go through them (you can see all of them by scrolling up and down)

I don't even know if this is possible, but hopefully someone can help me with these tasks.

THANK YOU in advance!

[June7]

1. This is simply moving to a new record.

2. This is a form set to Datasheet view or Continous view.

[tanveerksingh]

1. This is simply moving to a new record.

2. This is a form set to Datasheet view or Continous view.

Thanks for your help! I'm very new to Access, so could you explain how to move to a new record? Also, how do I change to Continuous view?

[Missinglinq]

First off, you really need to take the time to learn at least the ABCs of Access, i.e. names of the objects, so that you can ask your questions and understand the answers.

You're speaking of duplicating Records, not Forms, as June7 has said! A Form is usually comprised of multiple Records.

• If you want the Records to appear as a spreadsheet would, with a single Row representing a single Record, you'd use a Datasheet View Form.
• If you want the Multiple Records to appear on the Form and have the ability to scroll up and down to view them, but have the ability to have more than one line of Controls per Record, you'd use a Continuous View Form.

To set the Form's Default View, open it in Form Design View

1. Go to Properties - Format
2. Set the Default View Property to either Datasheet or Continuous View
3. Now click on the Properties Cycle Tab
4. Make sure that the Cycle Property is set to 'All Records'
5. Save the Form

Now, when you reach the final Control on a Record, fill it in and hit <Enter> you should move to a New Record.

Linq ;0)>

[tanveerksingh]

Hi Missinglinq,

Thank you! That's helpful, but how do I move to a new record? I do see a button option that says "New Record" but Access doesn't allow me to click on it (it's in grey). What am I doing wrong here?

[Missinglinq]

That would indicate that your Form is Read-Only, for some reason.

Is your Form based on a Table or a Query?

If based on a Table, is your Form Bound to your underlying Table? In Form Design View, go to Properties - Data and check the Record Source Property; is the name of your Table listed in the box?

The reasons that a Bound Form cannot have New Records added include:

1. AllowAdditions for the Form is set to No
2. The underlying Query the Form is based on is Read Only
3. User doesn't have Read and/or Write Permission for the Folder where the Data resides.
4. Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
5. Form's Recordset Type is set to Snapshot
6. All Controls on the Form being Locked or Locked and Disabled.

To see if #2 is the case, from the Objects Dialog Box go to Queries and click on the Query that your Form is based on to open it. Now try to enter a New Record directly into the Query. If you're unable to do so, this is the cause of your problem.

If your Query is Read Only, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Linq ;0)>

[tanveerksingh]

Thank you!! It looks like now when I type into the any of the fields of the last record, a new record automatically appears below it (which is what I wanted).

[Missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>