List Box showing records with "yes" in tick box

[Bob]

I have a query based on horses with there tick box, I have created a form
with a list box showing horse names and there "yes" "no" tick options, What
I want to achieve is Horses only with "yes" in the tick box and be able to
change them to "no".......Thanks for any help

--







..........Jenny Vance

 

[Bob]

Got that done Now thanks, but I am trying to get the textbox on my form to
turn green when the horses checkbox is ticked. The tickbox is called
worksheet so I have tried in Expressions [Worksheet]="Yes" ..... turn to
green but it is not working any thoughts...Thanks Bob

 

[John Vinson]

I have a query based on horses with there tick box, I have created a form
with a list box showing horse names and there "yes" "no" tick options, What
I want to achieve is Horses only with "yes" in the tick box and be able to
change them to "no".......Thanks for any help

I'd suggest that you use a Subform instead, based on a query selecting
the horse's name and the yes/no field. You can easily uncheck the
checkbox - no code needed at all.

It can be done using a Listbox and some VBA code in its AfterUpdate
event but why bother with the extra complication?

John W. Vinson[MVP]

 

[Bob]

John , I have made a tubular Form with horses list with there check box all
seems fine , 2 things
There are black lines running horizontal after each horse name that I can
not find to delete
And how do I get the report to only print yours checked true
Thanks for your help....Bob

 

[Larry Linson]

John , I have made a tubular Form with horses
list with there check box all seems fine . . .

A "tubular form"? Whazzat?

Larry

 

[Bob]

Auto Form /Tubular, Showed all records and there tick boxes next to there
name......Bob

 

[John Vinson]

A "tubular form"? Whazzat?

Maybe those people who have been ranting for years that Access is
"going down the tubes" were right after all! <g>

John W. Vinson[MVP]

 

[John Vinson]

John , I have made a tubular Form with horses list with there check box all
seems fine , 2 things
There are black lines running horizontal after each horse name that I can
not find to delete

Open the Form in design view, and change its Default View property
from Datasheet to Continuous. If necessary, move all the controls to
the top of the detail section and set their Border Style property to
Transparent; drag the bottom of the detail section up to the bottom of
the controls.

And how do I get the report to only print yours checked true

Base it on a Query with True as the criterion on the field.

John W. Vinson[MVP]

 

[Bob]

Thanks John printing to true in criteria working, But form is in (Continuous
Forms) and still getting a thin black line under details bar
Thanks Bob

 

[Bob]

AH HA Dividing Lines little trick to catch you out, Thanks now I have to
find out how to get rid of the boxes on the left......Bob

 

[Bob]

AH HA and there called [Record Selectors] tricky little things got rid of
them....Thanks Bob

 

[Bob]

John, is it possible to have 2 Continuous columns on a form so as if you had
40 records to show 20 on each side of the form as the records are not that
wide...Thanx Bob

AH HA and there called [Record Selectors] tricky little things got rid of
them....Thanks Bob

AH HA Dividing Lines little trick to catch you out, Thanks now I have to
find out how to get rid of the boxes on the left......Bob

 

[John Vinson]

John, is it possible to have 2 Continuous columns on a form so as if you had
40 records to show 20 on each side of the form as the records are not that
wide...Thanx Bob

Only by using two subforms, based on queries selecting the desired
subset of the records. Doable but not particularly easy!

John W. Vinson[MVP]