Entered data in query to form

S

st_moose

I have a query that the user inputs last name of the customer and
wants the output to be a specific form (that form is the form that all
the information is entered originally). How do I set up the form to
print to the created form instead of to the optional columnar,
tabular, datasheet or justified?

Hope this makes sense.

thanks
 
P

pietlinden

create a report and use it to format your data any way you want in any
layout you want.
 
J

jimfortune

Hope this makes sense.

st_moose wrote (paraphrased):

I have a query with a parameter for the Last Name of the customer.
When the user runs the query they type the Last Name into the box that
comes up. The user wants a report to come up where the data is
arranged the same as it was on the form used to input the information
originally. How do I set it up so that the report prints in this
format rather than the way the query shows it?

Create a report and find the menu item called Properties. Then under
the 'All' tab click to the right of the 'Record Source.' Then click on
the three dots. Select the query you are using. Highlight the first
field then hold down the shift key and highlight the last field. All
of the fields should turn blue. Click and hold the mouse button down
on the blue area and drag all the fields into the first box labeled
'Field:.' Close the QBE editor with the X button and click 'Yes' to
save the changes. Now select 'Field List' from the 'View' menu. You
should be able to drag each field onto the Detail section of the
report. Then you can arrange them in a way that looks like the input
form. When the user opens the report, the query will run and prompt
for the Last Name like always. Note that if several people have the
same last name the report will have several pages.

I hope this helps,
James A. Fortune
 
Top