Re: why can I still edit data when I set the "allowedits" property to

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If there is an edit in progress when you set the form's AllowEdits property
to No, Access does not apply the property until the recrod is saved. That's
just as well, or you would be stuck with an unsaved edit.

Now, if you dirty the record programmatically, you are back at the place
where Access has to let the edit complete. If you do this in an event such
as the Current event of the form, or the AfterUpdate event of the form, the
form is *always* dirty, and so the AllowEdits never gets to take effect.

For your second question, you need a related table to hold the multiple
matching values. Then interface it with a subform, so you can enter multiple
choices, one per row, in the subform. It is not possible to choose multiple
values in a combo, and trying to use an unbound multi-select list box to
handle multiple related values is very messy: you mut program at least the
form's Current, BeforeUpdate, and Undo events. The subform works with no
programming required.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Walt E" <Walt E@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52446890-8F44-4CEE-A51C-E2C9BC1C81B6@xxxxxxxxxxxxxxxx
Using Access 2000, I can't prevent editing of data without locking each
control individually. The form properties have no apparent control.

Also, how can I fill multiple fields from one table to another using a
drop
down list box? Or what VB code format can be used to set control values
in a
VB expression to set a First Name text box value to the First Name field
value in a lookup table when the drop down list box bound column is Last
Name?


.

Relevant Pages

  • Cant stop user from editing form
    ... I’m having a problem getting the AllowEdits property to work. ... This works fine and when the user tries to edit a field on the form he is ... if the user clicks in or enters the control cboLookup1 ... Dim varExtCost As Variant ...
    (microsoft.public.access.formscoding)
  • RE: Mulichoice Column Rendering in MOSS
    ... \par As for the multiple select column, I've performed some simple test as below: ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support ... These fields are placed in an edit panel and our authors ... \par would like to be able to display items in multiple columns to enhance ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Change + to -
    ... Place -1 in an empty cell ... Edit, Paste Special, Multiply ... Progression of multiple changes to a constant ...
    (microsoft.public.excel.misc)
  • Re: Create Excel-like view in Access form
    ... If there's a possibility that multiple users could interfere with each ... There's an introductory presentation on Access in a Multiuser Environment ... > temporarily hold the data while they edit it - is the way I usually handle ... > teacher or administrator to try to edit the data at the same time - but it ...
    (microsoft.public.access.forms)
  • Re: record becomes read only after updating
    ... >>wanted to edit a record... ... > Put a command button on the form to switch the AllowEdits property to ... switch the AllowEdits back to False in the Form's ...
    (microsoft.public.access.formscoding)