carry certain data from 3 forms to one printable form

[BadKitty]

is there any way to carry specific data entered by the user from 3 forms to one printable form which is set up like a city permit? ideally, i'd like the user to be able to click on a button to open the permit & then click print after having entered all the data into the 3 forms (1st form opens 2nd; 2nd opens 3rd).
ie - a contractor comes in & applies for a permit, the user (permit clerk) enters all the contractor's info into form 1 then clicks permit & enters the info for that specific permit (there are 4 types) into form 2, then clicks payment & enters check #, fee, etc. into form 3. the permit should now be issued but only needs to have permit #, contractor name, date, location, & amount paid on it. is this possible? i've tried building a query to base a report on with the with that info but am not gettin the results i want, and i don't know how to have a report display only one permit at a time. plus, my users don't want to have to run a query & then print a report. they just want to click print after entering the data (they're very lazy, set in their ways, and not very computer literate). please excuse my dumbness but the whole application is up & running except for this last part. please help! thanx in advance.

 

[CEH]

Well Im not one of the experts here,but I use a lot of reports off of forms showing one record. So I'll post on that one... First do a query for your report, that returns the info on the permit you are seeking... permit #, contractor name, date, location, & amount paid.... Once you have that returning all permits then you can narrow it to the one on your form by referencing THAT permit number in your criteria.
For example... If your form was called "Permits" and the textbox that held the permit number was called "Permit#" then in the criteria of the Permit# field in your query you would put.... [Forms]![Permits]![Permit#] .... This should make your report only show info for the current permit# on the form.

 

[RuralGuy]

You should be able to achieve the results you want by using the WhereCondition of the OpenForm command.

 

[BadKitty]

thanx...a bit more info please

thank you both for your suggestions. i apologize for being pretty much a novice & really apprecaite your help.

CEH
i've created the queries you suggested, but i'm not the one who will be printing the permits. i don't want the users to see the query at all (ie - run query button). is there a way i could have the user specify the criteria w/o deviating from the last form and then just have the report of that record printed? the other thing is, i have 4 seperate queries since there are 4 types of permits.....this complicates it a bit more.

RuralGuy
your suggestion seems a bit simpler & would like to try that...not exactly sure how though. i read another one of your posts which mentioned that you can pass data to the next form in the OpenArgs argument of the OpenForm command. is it possible to pass a little data from 3 forms to a form that is designed like a permit & then have the user be able to simply click print???



by the way, i'm having a bit of trouble accessing all the areas of the forum since the incident. if possible, would you mind e-mailing me your suggestions too? thanx!

 

[RuralGuy]

Hi BadKitty,
There are several ways to accomplish what you are trying to do. If all of the other forms are still open then you can retrieve the required information directly from them through the Forms collection. Me.Control = Forms!FirstForm.FirstControl Without knowing more about your particular layout it is difficult to give more detailed suggestions.

 

[BadKitty]

more info about my DB

thanx for getting right back to me. all the forms will still be open at the time the permit will be printed, so this seems like my simplest option. i'll play around w/the info you gave me, but i'll also attach my database so you can see exactly what i mean. again, much appreciation!