checkbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brino - 19 Sep 2006 05:11 GMT

hi all ,

i have a check box on a form.
when this checkbox has a tick in it , this must enter certain text into
another field of the table that the form is bound to.
how can i do this? with some code in the checkbox properties ???

thanks
brino

Reply to this Message

Wayne Gillespie - 19 Sep 2006 06:52 GMT

>hi all ,
>
[quoted text clipped - 5 lines]
>thanks
>brino

On the AfterUpdate event of the checkbox -

If Me.MyCheckbox = True Then
Me.SomeOtherTextbox = "Something"
Else
Me.SomeOtherTextbox = Null
End If

Wayne Gillespie
Gosford NSW Australia

Reply to this Message

brino - 19 Sep 2006 13:15 GMT

> >hi all ,
> >
[quoted text clipped - 16 lines]
> Wayne Gillespie
> Gosford NSW Australia

thanks heaps wayne !
i dont believe it ... i used to live in Gosford .... now im in
Melbourne
thanks again
brino

Reply to this Message

nilrickbl - 02 May 2008 19:45 GMT

Hi Im new to this forum, hope you can help

I have a very similar issue:
I have a table named ACC Table.
In this table I have one colunm named ACC.
I created a form based on this and now have a text box bound to ACC of the
table.
Now I want to creat several check boxes, that when checked(true), a certain
text will show in the ACC text box. If several or all of these check boxes
are checked, all the different text will show in the text box. So when I go
back to the table I will have all the text that was clicked, in the cell.
I tried the small sample below to no avail.
Please help I have been working on this thing for like a week.
Thanks,
Nil

>>hi all ,
>>
[quoted text clipped - 12 lines]
>Wayne Gillespie
>Gosford NSW Australia

Reply to this Message