Re: Open a form with all date disabled

Thanks for NO help. I am trying to learn VBA but it takes time. If im not
sucessful in writing my own code then that's when i ask for someones
assistance and when the code is right, i will then teach myself how it works
and what i was doing wrong.

"Jeff Boyce" wrote:

> 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