I have a button on a form that I would like to take results to a report. This all works well with a single table but when I have multiple tables with the same ID field name "ID" it does not work. The form with the button on it comes from a query that has three tables on it all having ID as key field. (know now probably should not have done that). The query only has the ID from the table I want to use on report. Error indicates it has more than one ID field. Following is portion of event procedure.
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenReport stDocName, , , stLinkCriteria
My question, is there a way to be table specific in the stLinkCriteria command? If not, any thoughts on how to get around this/ Thanks WWV
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenReport stDocName, , , stLinkCriteria
My question, is there a way to be table specific in the stLinkCriteria command? If not, any thoughts on how to get around this/ Thanks WWV