Inserting a page break

[terryc]

I was reading a question/response from 2004. To insert a page break, in a
form, there is a page break control in the toolbox. I'm using 2007 at work
and 2003 at home. I can't find it. I do print the form because it seems I
can't use a combo box on a report. Thanks

 

[tina]

i'd recommend against printing a form. AFAIK, you can use a combobox control
on a report, but it's pretty ugly. the normal procedure, though, is to
include the combobox's RowSource table in the report's underlying
RecordSource query, so you can display the field you need in a textbox in
the report, rather than using a combobox control. if the combobox control on
the form has a value list as RowSource, rather than a table, then this is a
good reason to move the value list into its' own table, base the combobox's
RowSource on that table, in the form, and include that table in the report's
RecordSource query.

hth

 

[terryc]

I understand some of what you are saying. The RowSource is a query. The
combobox name is "Resident_List" and the fill-in value is from a macro. A new
table would be a duplication of data and there are so many queries and
reports that include the resident's names. I don't understand how to use a
text box in the report. Thanks.

 

[tina]

A new

table would be a duplication of data

well, i suggested a new table *IF the combobox's RowSource were a value
list*, but since you say the RowSource is a query, the suggestion does not
apply. if it's residents' names you're needing for your report, and you have
those values stored in a table, then include that table in the report's
RecordSource, as i said before.

hth