Create Report Based on Form

[cclark9589]

Basically what I'm trying find out and haven't been able to find a specific answer to is whether or not I can create a report from a form?

The Clients form has a subform that lists all current jobs which can be in various stages. Each job displays the current billable info; accounting fees and expenses. Once a job is either completed, cancelled or referred I need to create an invoice for that job and bill it out.

I created a dblClick event on the Clients subform that opens the relevant Job form. On the Job form there is some additional information that needs to be entered such as updating the status of the job (completed, etc.), fieldwork date, report date, and time period looked at. Additionally, I may have to adjust the billable fees for one reason or another.

Once I finish entering this information I want to print the invoice based on this form. Can I create the report based on the form or must I do it based on a table or query?

Secondary question concerning the dblClick event. Is there some way of doing this based on the line rather than a particular field in the line? The only way I can currently see to this is by creating a dblClick event for each of the fields which seems to be rather redundant.

Sign me; "Learning, but still a dummy!"

Thanks in advance.

 

[Mike375]

You can save a form as a report and the report will be based on the same query or table. Forms have no data, they only display data so a Report can never actually be based on a Form.

With your DoubleClick if you want each textbox to have the same event and without individually doing it then that can be done if it is a macro.

In design view put the mosue on the vertical ruler on the left and you will get an arrow that points to the right. Right click and a menu opens, select poroperties and Events. Enter the macro name. That will put the maco on each of the text boxes. I have not treied it with code, but to try just enter the code in the normal way via the three dots and code builder etc.

Edit: I just tried that with code but it would not allow me to opend the code builder.

 

[cclark9589]

Thanks for the tip on the report.

I tried what you suggested about pointing to the left ruler and selecting properties but there's nothing to select under Event. I'm running Access 2007 if that makes a difference.

I've got it to work by using the dblClick event for each field. I'll see if I can get the macro thing figured out.

 

[Mike375]

A2007 might be different, don't know.

But when you do it all the texboxes will be highlighted. Maybe the attached screen shot will help.

 

[Mike375]

I forgot to add this one, after Properties is clicked. Notice muliple selection in attached