Report based on Data from a Form

[BillBee]

Can I create a form based on data in a Form or do I have to create a query and work from that. I want to print a label which contains two numbers(Class and CageNo) The two numbers can be obtained from from a table(Entries)via a combo box or could be typed directly into a Form created for that purpose. The purpose of this is to have a backup in case an original label is lost or damaged and I want just print off a single label.

 

[tuxalot]

Should be no problem to create a report using data from a form. Add unbound controls to your form, and insert the appropriate controls on your report, calling them on the report with a control source pointing to your form. Example:

on your form you have an unbound textbox control called txtFieldHere

Call it on your report by placing a textfield on the report, with a control source like this:

=[Forms]![frmMain]![txtFieldHere]

Works the same for other controls as well.

HTH

Tux

 

[BillBee]

That is not working for me. Using that format I am getting message saying the record source does not exist and to go to properties and set record source to a table or query.

 

[boblarson]

That is not working for me. Using that format I am getting message saying the record source does not exist and to go to properties and set record source to a table or query.

Yes, your report needs to have a recordsource - either a table or a query. Normally you would use a query to pull the applicable information to the report.