You decide what you think is appropriate. I would selectively lock and/or disable controls if the users can't leave the values alone.
Duane Hookom MVP
MS Access
> To: MS_Access_Professionals@yahoogroups.com
> From: Bill.Singer@at-group.net
> Date: Mon, 5 Nov 2012 04:03:36 +0000
> Subject: Re: [MS_AccessPros] Open on Blank Record
>
>
> Duane,
> So in the "ON OPEN" event I could set the edit property to NO.
>
> I did not see a LOCKED property.
>
> When the EDIT property is set to NO my combo box does not work either.
>
> Or.. should I set the LOCKED property of the last name field to YES on OPEN and then unlock it at the exit of the combo box?
>
> I am thinking out loud but am I on the right track?
>
> Thanks,
> Bill
>
>
>
> -----Original Message-----
> From: Duane Hookom [mailto:duanehookom@hotmail.com]
> Sent: Sunday, November 4, 2012 09:10 PM
> To: 'Access Professionals Yahoo Group'
> Subject: RE: [MS_AccessPros] Open on Blank Record
>
> You can default the form to locked and then unlock the controls based on some event.
>
> Duane Hookom MVP
> MS Access
>
> > To: mailto:MS_Access_Professionals%40yahoogroups.com
> > From: mailto:Bill.Singer%40at-group.net
> > Date: Mon, 5 Nov 2012 01:52:47 +0000
> > Subject: [MS_AccessPros] Open on Blank Record
> >
> > I have a client Lookup up combo box on a form which contains the client information including last name and first name.
> >
> > Despite ongoing training the users periodically by pass the Lookup Combo box and go to the last name field of the form and type in the name they are searching for. This changes the data on the first record that shows up on the form when the form is open.
> >
> > Is it possible to open a form to a blank record without it being a New record?
> >
> > Any other ideas on how to prevent the first record from this user error?
> >
> > Thank you,
> > Bill
> > MN
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar