using a form to fill in a text report

recon0302

Registered User.
Local time
Today, 01:44
Joined
Oct 9, 2002
Messages
27
I have a report that contains mostly text with only several fields. I need to fill in address information that is not stored as data in the database. I have created the form using a specific table as its record source and then created unbound text boxes. The drawback is that the text boxes have to be filled in separately which means several have to be filled in in succession. Is there a way to create a form that can be filled with unbound data that will insert the data into the report for me in the text fields I need filled? Not good with VB (although I am learning that I need to educate myself here). Thanx

Marty
 
I meant to say I created a "Report" that has a table as its record source, not form.
 
I got it. Don't know where I left my brain. I forgot how simple it was until I looked at it for a minute. Tried to overcomplicate things. Unbound form, create unbound text box in report, link these boxes to the fileds in the unbound form fields. Create command button to open the report. Use macro to print page 1 of 1. Put this macro in the report properties in the OnActivate field. Done.
 

Users who are viewing this thread

Back
Top Bottom