Cycle

  • Thread starter Thread starter Jeff Boyce
  • Start date Start date
J

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
 
"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!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
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)
 
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
 
Back
Top