Re: Open a form with all date disabled

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you are going to be working in Event Procedures, it would be worth your
time to learn a little about VBA... Otherwise, if someone just writes your
code, then tells you where it goes, then tells you how to debug it if/when
it doesn't work exactly right the first time, then ..., you'll have little
incentive to learn it and you certainly won't understand it!

Or you could check with a local area users group for someone for hire...

Regards

Jeff Boyce
<Access MVP>

"StuJol" <StuJol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FE733B68-87BF-4271-B589-89A138CA46F8@xxxxxxxxxxxxxxxx
> Could you please write the code for a simple if.. then statement as im not
> familiar with the code as im just getting use to Access
>
> "Jeff Boyce" wrote:
>
> > If you add a procedure to the OnCurrent event, you can use that to check
the
> > contents of the row/record as it is being loaded to the form.
> >
> > It sounds like you want to set the form's Data Edit property to "No" if
your
> > status field value corresponds to "Closed". A simple If... Then
statement
> > could handle this.
> >
> > --
> > Regards
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "StuJol" <StuJol@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:67F9D31D-826B-49D6-B149-DDB2F3869286@xxxxxxxxxxxxxxxx
> > > I have a form with text boxes and combo boxes on. When the "Status"
combo
> > box
> > > value is "Closed" i want the form to open with every txt box and combo
box
> > > (Including the "Status" Combo box) disabled so that no fields can be
> > changed.
> > > Read Only.
> > >
> > > Does anyone know any code that will do this???
> >
> >

.

Relevant Pages