Checkbox on Forms

[jdub via AccessMonster.com]

I created a form that lists all the players from a particular squad in my
database. I used the Wizard to create the form and populate the form with
the results from a sqad query. It works. My next phase is to add check
boxes to the form to allow the user to select the appropriate players that
will play in the next game and send the selected players to a form for
printing. I'm facing two issues. The first is that when I added the
checkbox to the form, each player returned in the form has a checkbox, which
is good. But when I select one checkbox it enables all of the checkboxes.
The second issue is how to I get the selected players to a report that will
list them in a column under Player Name? Any help would be greatly
appreciated.

Thanks

JW

--
<link removed>

[jdub via AccessMonster.com]

Thanks for your reply. Maybe I'm not clear in my explanation. I'll try
again.

I've created a form that pulls players names from the database(Player Name).
On the form by each name I've inserted a Checkbox and it's bound to the
RosterField. RosterField is a YES/NO datatype field. I also created a
command on the same form that will open up a report and supposedly input the
selected players.

The command button on the form is a Preview Report Button: The Event
Procedure code for On Click is below:

Private Sub Preview_Report_ Click()
On Error GoTo Err_Preview_Rep ort_Click

Dim stDocName As String

stDocName = "GameRoster "
DoCmd.OpenRepor t stDocName, acPreview

Exit_Preview_Re port_Click:
Exit Sub

Err_Preview_Rep ort_Click:
MsgBox Err.Description
Resume Exit_Preview_Re port_Click

End Sub

So far everything is good. The GameRoster opens up but is only displaying
the headers I created. I assume that there has to be a field or fields
designed in the Detail portion of the report that will store the selected
Player Names. Does that make sense? I've created reports and associated the
fields under my column headers with fields from the database. But in this
fashion, how and where in the report do I get the selected player names on
the report?

Thanks,

Jdub
w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:

If you're asking me about creating a report the best way is to select your
table in the database window and then click Insert | Report and choose
report wizard. Follow the prompts. Make a report. If you don't like how
it looks, delete it, do it again. The wizard is pretty simple. By the way,
tip: You don't have to display a field to filter by it. In other worods,
this statement:

docmd.openrepo rt "MyRoster", , , "InRoster=T rue"

works whether InRoster appears on the report as a checkbox (or anything
else) or not. As long as the recordsource of the report is the table
itself, you have all the fields in that table available to you. You display
the players' names on the report by putting a control on the report and
using the player name field as the controlsource.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[jdub via AccessMonster.com]

Your quote "You display

the players' names on the report by putting a control on the report and
using the player name field as the controlsource."
I reread this statement and understood it this time. Okay, you say "putting
a control on the report". Is a text box with a control source considered a
control? I created a text box under my player name header and tied it to the
Player Name field of the database. I ran my form and selected 5 players.
Click the Preview Report button and there is only 1 of the 5 players selected.
Looks like we're getting close. I'm missing something.

Thanks for your patience by the way. :-)

Jdub
w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:If you're asking me about creating a report the best way is to select your
table in the database window and then click Insert | Report and choose
report wizard. Follow the prompts. Make a report. If you don't like how
it looks, delete it, do it again. The wizard is pretty simple. By the way,
tip: You don't have to display a field to filter by it. In other worods,
this statement:

docmd.openrepo rt "MyRoster", , , "InRoster=T rue"

works whether InRoster appears on the report as a checkbox (or anything
else) or not. As long as the recordsource of the report is the table
itself, you have all the fields in that table available to you. You display
the players' names on the report by putting a control on the report and
using the player name field as the controlsource.

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[w_a_n_n_a_l_l_ -]

this would be a lot easier if you would post the table designs (at least the
primary and foreign keys, a few fields of interest, and anything related to
the task).

When you say things like "On the form by each name I've inserted a Checkbox
and it's bound to the RosterField" I can't tell what you've done.

If you're using a continuous subform to display a list of names, you'd have
exactly one checkbox in the detail section next to the player name, if your
underlying table contains the name and the yes/no field.

Without good solid info like that, this is an exercise in futility.

Please - table designs, just for a start.

[jdub via AccessMonster.com]

Okay,

Here is my Main Registration Table and the fields of importance.

Registration Table

PlayerID Autonumber - Primary Key
SSN Text
Player Name Text
..
..
..
..
Squad Text
RosterField Yes/No

More to come..

w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:

this would be a lot easier if you would post the table designs (at least the
primary and foreign keys, a few fields of interest, and anything related to
the task).

When you say things like "On the form by each name I've inserted a Checkbox
and it's bound to the RosterField" I can't tell what you've done.

If you're using a continuous subform to display a list of names, you'd have
exactly one checkbox in the detail section next to the player name, if your
underlying table contains the name and the yes/no field.

Without good solid info like that, this is an exercise in futility.

Please - table designs, just for a start.

--
Message posted via http://www.accessmonster.com

[jdub via AccessMonster.com]

I created a form called DJF Registration Table222 - The form has a record
source of DJF Registration Table(This is my main registration table)

Form Header
Detail Header
Label - Player Name Text Box with Control Source Player Name
Checkbox with Control Source Rosterfield

Form Footer

Preview Report Button with the following code for the On Click Event
Procedure

Private Sub Preview_Report_ Click()
On Error GoTo Err_Preview_Rep ort_Click

Dim stDocName As String
Dim strWhere As String

stDocName = "GameRoster "
DoCmd.OpenRepor t stDocName, acViewPreview
Exit_Preview_Re port_Click:
Exit Sub

Err_Preview_Rep ort_Click:
MsgBox Err.Description
Resume Exit_Preview_Re port_Click
End Sub

I'm able to receive the players listed in the DJF Registration Table222 form.
I'm able to select the checkboxes appropriately based upon the player I would
like to listed on the report. The problem comes when I click the Preview
Report button for the GameRoster Report. The GameRoster Report opens and
there is only 1 entry(the first entry in the database), even though I
selected multiple players on the DJR Registration Table222form.

The Record Source for the report is the DJF Registration Table. I created a
text box with control source Player Name.
Does that help any?
jdub wrote:

Okay,

Here is my Main Registration Table and the fields of importance.

Registration Table

PlayerID Autonumber - Primary Key
SSN Text
Player Name Text
.
.
.
.
Squad Text
RosterField Yes/No

More to come..

this would be a lot easier if you would post the table designs (at least the
primary and foreign keys, a few fields of interest, and anything related to

[quoted text clipped - 10 lines]

Please - table designs, just for a start.

--
Message posted via http://www.accessmonster.com

[w_a_n_n_a_l_l_ -]

Yes it helps, although I'm still not sure what "Deatil Header" means, but
later for that. This code:

stDocName = "GameRoster "
DoCmd.OpenRepor t stDocName, acViewPreview

should be printing every record in your registration table, unless you've
restricted the recordsource somehow, but you say that the recordsource of
the report is the table itself.

How many pages do you get in Print Preview?

[jdub via AccessMonster.com]

Detail Header is listed when you're in design view of a form.

I only get 1 blank page.

w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:

Yes it helps, although I'm still not sure what "Deatil Header" means, but
later for that. This code:

stDocName = "GameRoster "
DoCmd.OpenRepor t stDocName, acViewPreview

should be printing every record in your registration table, unless you've
restricted the recordsource somehow, but you say that the recordsource of
the report is the table itself.

How many pages do you get in Print Preview?

--
Message posted via http://www.accessmonster.com

[jdub via AccessMonster.com]

I double checked and yes the RecordSource is the registration table for the
report GameRoster. I have defined a text box field on the report which is
the Control Source for the field Player Name, which comes from the
registration table.

w_a_n_n_a_l_l_ -@-_s_b_c_g_l_o_b_ a_l._n_e_t wrote:

Yes it helps, although I'm still not sure what "Deatil Header" means, but
later for that. This code:

stDocName = "GameRoster "
DoCmd.OpenRepor t stDocName, acViewPreview

should be printing every record in your registration table, unless you've
restricted the recordsource somehow, but you say that the recordsource of
the report is the table itself.

How many pages do you get in Print Preview?

--
Message posted via AccessMonster.c om
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[w_a_n_n_a_l_l_ -]

There is no Detail Header. There are Form Header, Page Header, Detail, Page
Footer and Form Footer. Detail refers to the Detail section, as Form Header
refers to the Form Header section.

[w_a_n_n_a_l_l_ -]

OK. Try this. WIth your report in design view, click on the RecordSource.
You should see s button with three dots appear. Click on that button, click
yes (you want to build a query on a table). That opens the query design
grid. You'll throw this one away, but I need to know what you get. From
the list of table fields, drag the "*" down to the grid. then run the
query. How many rows of data do you see?