Help! Form Won't Open in Add-Mode

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

The Main Form in the Access 97 database that I'm working
on will not open up in Add mode and I can't figure out
why.

The source of the form is a query with three tables joined
in two one-to-many relationships. When the form is opened
with a button from the switchboard, or when it is opened
from the database window, it always displays the existing
record--never a blank form to allow entry of a new
record. The Allow Edits, Deletions, Additions settings
are all set to Yes. The Data Entry setting is set to No.
On the SwitchBoard, the Open Form command is set to Open
Form in Add Mode. Does anyone have any idea what the
problem might be? I've checked everything I can think of
but haven't found a solution. I'd be greatful for any
insight.
 
Kathy,

Could be one of a couple of problems.

If you want it to open to a 'blank' new record, change the
DataEntry setting to True. This is what it does.

If you can't get a new record period using the record
navigation buttons at the bottom left of the form, your
underlying query may not be updateable. Can you make changes
to the existing records? If not, can you make changes in the
query itself without the form interface? If not, your query
design is the culprit.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
You're right! It's the query. I can't modify the records
in the form or in the query and now get a message
saying "recordset is not updateable". Thank you for your
help--the query is being rewritten.
 
Back
Top