Cycle

[Jeff Boyce]

We aren't there. We don't know what query you are using.

Please post the SQL-statement of your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Linq Adams via AccessMonster.com]

"Why cycle (all records) not work on my form
I set data entry = Yes"

With DataEntry set to Yes you CANNOT view existing records, regardless of
whether Cycle is set (all records) or not.

DataEntry = Yes ONLY allows new records to be entered!

 

[a]

Why cycle (all records) not work on my form

I set data entry = Yes

The form based on query == Query Criteria is

Forms!FormName!ControlName

(The ControlName is on the form)

 

[John Smith]

That is what it is intended to do, allow *only* data entry.

If you want to allow viewing of existing records and entry of new ones then
you require:

DataEntry = No
AllowAdditions = Yes

HTH
John
##################################
Don't Print - Save trees