Re: Checkbox on Forms

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_ -@xxxxxxxxxxxxxxxxxxxxxxxxxx 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.openreport "MyRoster", , , "InRoster=True"

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.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200606/1
.

Relevant Pages

  • Re: Minimum width and Author name
    ... although the player will display a 1 pixel ... The minimum height to display the control bar is 40 pixels for all ...
    (microsoft.public.windowsmedia.sdk)
  • Re: PLEASE HELP: Refresh columns displayed in a report from a quer
    ... I have basically put about 10 extra columns in the report, ... column display is driven by user selection on the form, BUT is there a way to ... are operating at run time, not design time, so CreateReport ... ' Create new text box control and size to fit data. ...
    (microsoft.public.access.reports)
  • Re: PLEASE HELP: Refresh columns displayed in a report from a quer
    ... are operating at run time, not design time, so CreateReport ... properties in the report ... is that the reports are displayed in separate pages and, ... ' Create new text box control and size to fit data. ...
    (microsoft.public.access.reports)
  • Re: PLEASE HELP: Refresh columns displayed in a report from a quer
    ... A report opened in preview or normal view (only ... column display is driven by user selection on the form, BUT is there a way to ... are operating at run time, not design time, so CreateReport ... ' Create new text box control and size to fit data. ...
    (microsoft.public.access.reports)
  • Re: PLEASE HELP: Refresh columns displayed in a report from a quer
    ... A report opened in preview or normal view (only ... column display is driven by user selection on the form, BUT is there a way to ... are operating at run time, not design time, so CreateReport ... ' Create new text box control and size to fit data. ...
    (microsoft.public.access.reports)