Query with Linked Tables not working with ComboBox

[MikeKohler]

Hi, I have a switchboard that when a combo box is used a report opens in preview view with the selected record. To get this result I use the criteria
Forms!Switchboard!cmboName in the underlying query.
This works fine when the query consits of one table. But when there are multiple tables the report opens, but is empty.
Thank you,
Michael kohler

 

[dhookom]

You have all of your joins wrong as well wrong data types of all fields and ...

If I am wrong you might want to provide some table structures, sample data, as well as the SQL view of your query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MikeKohler]

You're right, I had to change my table structure. I'm creting a whale monitoring database, and I had split the data based on sex, so I had females in a different table linked to the main table containing males. I combined the data into one table and using different queries, I can now have the user select male or female whales based on a unique identifier. The reason for the female/male split is that the report for the females has calf information so it is formatted differently.