Hey,
I have a form with a combo box and some buttons. The user selects a Claim Number from the combo box and then selects a button in order to view whichever report they would like to see.
I am now in need of a button which pulls all of the data pertaining to that Claim Number from every table in the database. So, in other words, user selects a Claim Number from the combo box, hits a button, and then gets a report that has all of the data from every single table regarding that certain Claim Number.
My first thought was simply a query that utilizes all of the tables and in the "Criteria" field, put Like "*" & [Forms]![frmEntry1]![cboClaimNumber] & "*" Or Is Null, but apparently if you have all fields selected from each table, and multiple tables on top of that, you cannot specify certain criteria.
Anyways, any help/guidance would be awesome. Thank you in advance.