printing parts of records in a specific format

[BadKitty]

i've created a database for city permits to be issued (which works perfectly thanx to alll your help), but now i need to be able to print out 1 permit at a time when it is issued (immediately after the data has been entered into the forms). i have 3 tables & 3 forms: contractors/owners, permtOrders (which has tabs for the different types of permits), and permitOrderDetails. the problem is the forms are set up for data entry (and only open in add mode for obvious reasons)...i need to be able to print an actual permit (like the carbon copy, landscape kind that usually tears out of a book). once the user enters the information into the forms, i need a little bit of that info from each form to be carried onto the actual printable permit. i'm not really sure how to accomplish this. i don't really know if i explained this right, but any suggestions are greatly appreciated.

 

[richary]

1. You need to create a query which contains all the data you need for the permit across the 3 tables.

2. Make a report which is based on that query. Design the report to look like the permit(s) you wish to print off containing the fields from the query

 

[neileg]

It is usually best to use a report to print data. You can set up a report based on the same underlying data as your form, and include whatever data and whatever formatting you want.

 

[BadKitty]

thanx!

thanx for both of your help appreciate the prompt response. i haven't been in work the past 2 days, so i'll give it a shot today.

 

[BadKitty]

query trouble

k, i understand how it should work, but i'm not getting any results in my query when i include more than 1 table i've tried with & without the wizard. i get some results when i change the join type but then i only get results from one of the tables. any idea what i might be doing wrong? maybe i should use a different type of query?

 

[neileg]

Open your query in SQL view and copy and paste the SQL here so we can see what is happening.

 

[BadKitty]

query in sql

SELECT [tblContractors/Owners].company, [tblContractors/Owners].Lname, [tblContractors/Owners].Fname, tblPermitOrders.[permit#], tblPermitOrders.permitType, tblPermitOrders.block, tblPermitOrders.lot, tblPermitOrders.location, tblPermitOrders.dateReq, tblPermitOrders.[#ofDays], tblPermitOrders.Msize, tblPermitOrders.Tsize, tblPermitOrders.compStrain, tblPermitOrders.sewerType1, tblPermitOrders.sewerType2, tblPermitOrders.sewerType3, tblPermitOrderDetails.[Ck_MO#], tblPermitOrderDetails.date, tblPermitOrderDetails.fee
FROM ([tblContractors/Owners] INNER JOIN tblPermitOrderDetails ON [tblContractors/Owners].[c/oID] = tblPermitOrderDetails.[c/oID]) INNER JOIN tblPermitOrders ON [tblContractors/Owners].[c/oID] = tblPermitOrders.[c/oID];

thanx!