update a lbl depending on whether check box is ticked or not

[DP]

hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent
or not, when i go though the records, depending on whether the check box is
ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

[salad]

DP wrote:

hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent
or not, when i go though the records, depending on whether the check box is
ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

For myself, I'd keep the Available checkbox hidden and display a message
since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the
tick is set.

[DP]

sorry, its not a field. its a checkbox.

i want it to display 'film is out on rent' in lblOnRent, when the checkbox
is not ticked.
and diapllay 'the film is available' when the box is ticked. ,
the code u gave me dont work. i'm more confused now, dont u have to say
whether it is ticked or not?

thanx

dev
"salad" <oi*@vinegar.com> wrote in message
news:g%******************@newsread3.news.atl.earth link.net...

DP wrote:

hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent or not, when i go though the records, depending on whether the check box is ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

For myself, I'd keep the Available checkbox hidden and display a message
since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the
tick is set.

[DP]

hi,

this is wat i've got. ;

Private Sub CheckStatus()
If Available = True Then
lblOnRent = "This film is out on rent."
Else
lblOnRent = "This film is available."
End If
End Sub

and i call it when i click the next/previous button and load part.

the problem is, when i start the form, it says it says the films is
available, but it isnt.

how can i sort this little problem out.
dev

"DP" <[e-mail]> wrote in message
news:XM*******************@newsfe2-gui.ntli.net...

sorry, its not a field. its a checkbox.

i want it to display 'film is out on rent' in lblOnRent, when the checkbox
is not ticked.
and diapllay 'the film is available' when the box is ticked. ,
the code u gave me dont work. i'm more confused now, dont u have to say
whether it is ticked or not?

thanx

dev
"salad" <oi*@vinegar.com> wrote in message
news:g%******************@newsread3.news.atl.earth link.net...

DP wrote:

hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent or not, when i go though the records, depending on whether the check

box

is ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

For myself, I'd keep the Available checkbox hidden and display a message
since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the
tick is set.

[salad]

DP wrote:

hi,

this is wat i've got. ;

Private Sub CheckStatus()
If Available = True Then
lblOnRent = "This film is out on rent."
Else
lblOnRent = "This film is available."
End If
End Sub
Since you do not understand the advice given to you, you may be in over
your head. Perhaps you need a programmer to get you over the hump.

and i call it when i click the next/previous button and load part.

the problem is, when i start the form, it says it says the films is
available, but it isnt.

how can i sort this little problem out.
dev

"DP" <[e-mail]> wrote in message
news:XM*******************@newsfe2-gui.ntli.net...

sorry, its not a field. its a checkbox.

i want it to display 'film is out on rent' in lblOnRent, when the checkbox
is not ticked.
and diapllay 'the film is available' when the box is ticked. ,
the code u gave me dont work. i'm more confused now, dont u have to say
whether it is ticked or not?

thanx

dev
"salad" <oi*@vinegar.com> wrote in message
news:g%******************@newsread3.news.atl.ear thlink.net...

DP wrote:
hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on

rent

or not, when i go though the records, depending on whether the check

box

is

ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

For myself, I'd keep the Available checkbox hidden and display a message
since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the
tick is set.

[RoyVidar]

DP wrote in message <2w*******************@newsfe6-win.ntli.net> :

hi,

this is wat i've got. ;

Private Sub CheckStatus()
If Available = True Then
lblOnRent = "This film is out on rent."
Else
lblOnRent = "This film is available."
End If
End Sub

and i call it when i click the next/previous button and load part.

the problem is, when i start the form, it says it says the films is
available, but it isnt.

how can i sort this little problem out.
dev

"DP" <[e-mail]> wrote in message
news:XM*******************@newsfe2-gui.ntli.net...

sorry, its not a field. its a checkbox.

i want it to display 'film is out on rent' in lblOnRent, when the checkbox
is not ticked.
and diapllay 'the film is available' when the box is ticked. ,
the code u gave me dont work. i'm more confused now, dont u have to say
whether it is ticked or not?

thanx

dev
"salad" <oi*@vinegar.com> wrote in message
news:g%******************@newsread3.news.atl.earth link.net...

DP wrote:

hi,

i've got a film rental database., with a film table and form.

i've got a checkbox in the form called 'available'.
i;ve got a lblOnRent underneath. i just want it to say the film is on rent
or not, when i go though the records, depending on whether the check box
is ticked or not.

i;ve got this so far, but dont know wjere to put it;

If Availabe = True Then
lblOnRent = "This film is not available, it is out on rent."
Else

lblOnRent = "This film is available."
End If
End Sub

TIA.

dev

For myself, I'd keep the Available checkbox hidden and display a message
since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the
tick is set.

I'm kind of assuming I'm helping with a school assignement, true?

Try calling it from the on current event of the form, in addition to
the after update event of the control, and see if that helps.

--
Roy-Vidar

[DP]

thanx for the help, its working now. i was just confused on where to run the
code.

Dev

"RoyVidar" <ro*************@yahoo.no> wrote in message
news:mn***********************@yahoo.no...

DP wrote in message <2w*******************@newsfe6-win.ntli.net> :

hi,

this is wat i've got. ;

Private Sub CheckStatus()
If Available = True Then
lblOnRent = "This film is out on rent."
Else
lblOnRent = "This film is available."
End If
End Sub

and i call it when i click the next/previous button and load part.

the problem is, when i start the form, it says it says the films is
available, but it isnt.

how can i sort this little problem out.
dev

"DP" <[e-mail]> wrote in message
news:XM*******************@newsfe2-gui.ntli.net...

sorry, its not a field. its a checkbox.

i want it to display 'film is out on rent' in lblOnRent, when the checkbox is not ticked.
and diapllay 'the film is available' when the box is ticked. ,
the code u gave me dont work. i'm more confused now, dont u have to say
whether it is ticked or not?

thanx

dev
"salad" <oi*@vinegar.com> wrote in message
news:g%******************@newsread3.news.atl.earth link.net...
DP wrote:

> hi,
>
> i've got a film rental database., with a film table and form.
>
> i've got a checkbox in the form called 'available'.
> i;ve got a lblOnRent underneath. i just want it to say the film is on rent> or not, when i go though the records, depending on whether the check box> is ticked or not.
>
> i;ve got this so far, but dont know wjere to put it;
>
> If Availabe = True Then
> lblOnRent = "This film is not available, it is out on rent."
> Else
>
> lblOnRent = "This film is available."
> End If
> End Sub
>
> TIA.
>
> dev

For myself, I'd keep the Available checkbox hidden and display a message since it appears your yes/no field would not be updated on this form.
However, here's what your code could look like
If Available Then
lblOnRent.Caption = "This film is out on rent."
Else
lblOnRent.Caption = "This film is available."
End If

Reading the above, the captions seem reversed. I guess it's the way the tick is set.

I'm kind of assuming I'm helping with a school assignement, true?

Try calling it from the on current event of the form, in addition to
the after update event of the control, and see if that helps.

--
Roy-Vidar