Non Update Form

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a form with only one textfield which is a date. Included on the form
are three listboxes. The query for each of the listboxes perform a where the
date in the query matches the date on the form. It's that way for all 3
listboxes. I have set Allow Edits, Allow Deletions and Allow Edits to no.

It all works well except when I exit the form is burps saying that the file
operation couldn't be completed because it would create a duplicate entry in
the table.

How do I set up the form so that it doesn't try to update the records it's
querying?
 
If you have allow edits set to no, I would expect that the listboxes
wouldn't work.
Perhaps you have a form with a subform?

The listboxes would be unbound - I am assuming they are unbound.
What happens when user selects a record in the listbox?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
nope. I have the listboxes set to enabled/locked. all of the listboxes are
unbound. No subform on the form. Nothing happens when a user selects a
record...they can't select a record, the listbox is locked. It's a simple
query form consolidating information from 3 tables.
 
nope. I have the listboxes set to enabled/locked. all of the listboxes are
unbound. No subform on the form. Nothing happens when a user selects a
record...they can't select a record, the listbox is locked. It's a simple
query form consolidating information from 3 tables.
Click to expand...

If the Form's AllowEdits property is set to Yes then you cannot select a
record from a combo box or listbox (even if it is unbound); all controls on
the form are uneditable because the form itself is uneditable.
 
John,

Did you mean AllowEdits is set to No? Set to Yes, they can make changes...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
nope. I have the listboxes set to enabled/locked. all of the listboxes
are
unbound. No subform on the form. Nothing happens when a user selects a
record...they can't select a record, the listbox is locked. It's a simple
query form consolidating information from 3 tables.
Click to expand...

If the Form's AllowEdits property is set to Yes then you cannot select a
record from a combo box or listbox (even if it is unbound); all controls on
the form are uneditable because the form itself is uneditable.
 
John,

Did you mean AllowEdits is set to No? Set to Yes, they can make changes...
Click to expand...

If you want to be able to select (for navigation purposes) a record from a
Listbox or Combo Box, then the *form itself* must be set to allow edits. To
prevent updates to the table itself, you can either base the form on a
non-editable recordset (a Snapshot recordset, say), or set all the bound
controls to Locked = Yes, Enabled = No.
 
John,

Yes that is true but the way I read your reply it did not include the
Locked=Yes and Enabled=No and my speed reading caused me to mis that part of
the previous post. Tip toeing out...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

John,

Did you mean AllowEdits is set to No? Set to Yes, they can make changes...
Click to expand...

If you want to be able to select (for navigation purposes) a record from a
Listbox or Combo Box, then the *form itself* must be set to allow edits. To
prevent updates to the table itself, you can either base the form on a
non-editable recordset (a Snapshot recordset, say), or set all the bound
controls to Locked = Yes, Enabled = No.
 
Back
Top