Creating a report from data entered in a form

[Wizzy]

I created a form from a table but then aded text box with fields that are not in my table. Example I aded a text box for comments. How would I rectrieve this info? I would like to put the results in a report. Any help will be appreciated.

 

[rainman89]

create a textbox on your report whos control is =forms!yourformname.yourcommentfieldtextbox

 

[MSAccessRookie]

I created a form from a table but then aded text box with fields that are not in my table. Example I aded a text box for comments. How would I rectrieve this info? I would like to put the results in a report. Any help will be appreciated.

Would the comments ever need to be saved for future reference? If so, then you will need to add a column (Probably a Memo Type) to save them in at the end of your table, and bind the Field to that column. Your report could then use that column.

If the comments are a one shot that are no longer required after the report is printed, then rainman is exactly correct. Note that the Form must remain open until after the report is printed for the comment to be available.

 

[Wizzy]

Thanks this really helped me, but it's a drop down field and when i swithch from report design view it asks that i enter one of the selection on the drop down field. How can I have the report show everthing?

 

[rainman89]

????

What do you mean? you have comments stored in a dropdown that you want to show on the report? Thought it was a textbox?

 

[Wizzy]

Sorry. Your suggestions worked great for the text box, but I also have a few combo boxes that I would like to add to the report.

 

[rainman89]

Are the values in the combo box stored in a table? If thats the case you can create a query to add those to the report

if not you can do the same thing

create a textbox but this time use

forms!yourformname.yourcomboboxname.column(whatever column number has the info you want)

 

[Wizzy]

thanks. I'll try this.

 

[Wizzy]

Thanks! Rainman89 this worked!