Create report containing data from main form and subform

[loslobo]

Hello all....

I've finally broken down and decided to consult this forum personally for help! I've learned so much from lurking at various threads as I've researched different topics on Access, but I've hit a wall and really need help.

I'm trying to create a report that contains data from a "main" form and a subform. However, I can't get the main form data to populate no matter what I try.:banghead:

I've been through all sorts of queries and just can't get it to work. The main form and subform are both separate tables, and there are no redundant fields.

Basically, the main form is an inventory of assets, and the subform is designed as a way to submit trouble tickets when one of those assets requires maintenance or repair.

I hope I'm asking this correctly and not confusing anyone. Any help you can provide would be greatly appreciated!!

Thanks!

 

[JHB]

Do you've a form in a report, (because you write main/sub form)?
Use the wizard to create the report(s).
If you've put a form in the report are you sure the form is correct set up to show data, and not only for inputting new records?

 

[loslobo]

I've tried using the wizard but no luck.

I'm using a tabbed form. There's a lot of data fields for inventory information and it is spread out over several tabs. The last tab contains the subform for the trouble tickets.

The way the main form is set up is that I have four fields located in the form header. A user selects a particular asset from the header fields, and the rest of the fields are in the detail sections of each tab, and the data in those fields changes based on the selections from the header fields.

I need the report to to show the data that was selected in the header fields, as well as all of the data from the subform for the trouble ticket.

Thanks.

 

[loslobo]

OK...I've gotten the data from both tables to populate in the report via a query, but now the data is repeating.

Must be some issue with the JOIN, but I'm not sure how to make it stop!