RE: Display of records

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

From: Alicia (Alicia_at_discussions.microsoft.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 15:24:01 -0800

How about in the on current event you could loop through the controls and set
the locked property to true for all textboxes that are not null?

Or add a field to the main table and mark each record after it has been
edited?

"Bob Vincent" wrote:

> In my application the data entry person will complete a form that adds
> information to exising records in an underlying table. Based on advice I
> received here I am limiting the records they can see by use of a combo box
> with the limit to list value set to yes. I would like to prevent the data
> entry person from being able to view, or edit, a record once it has been
> edited one time. In other words they can pull it up once, add data to the
> blank fields, but once they exit the form I don't want them to be able to
> pull it up again.

Relevant Pages

  • Making a text box searchable
    ... Is there something to add to this code to make it pull all ... need two controls for. ... In the AfterUpdate event of IDFilter have code... ... If there is not the form will display the blank ...
    (microsoft.public.access.formscoding)
  • Re: Add record programmatically
    ... references to pull the ... >values from controls on open forms or the VALUES list ... >with a SELECT statement to grab rows from another table. ...
    (microsoft.public.access.formscoding)
  • Re: automatically fill controls from a new open form
    ... the windowmode. ... upon opening, if certain fields are filled, i would like ... pull those values into some of the controls of the new form. ...
    (comp.databases.ms-access)
  • Is this possible
    ... I have a form that a user can enter an ID number, pull the data back ... and edit and update the data. ... I have 4 controls that are dropdownlists populated by a database. ...
    (microsoft.public.dotnet.framework.adonet)
  • pulling information between 2 dates
    ... I have to textboxes one with start date and one with end date, ... dates in there and I'd like it for when I hit a runquery button it'll ... pull all dates between those respective dates. ...
    (microsoft.public.access.formscoding)