Matching exact data

  • Thread starter Thread starter MisJ
  • Start date Start date
M

MisJ

Hi I have built 2 tables: tblMain and tblPartNo. They are linked by Drawing
numbers. I want to find all Part numbers that are also drawing numbers and
later on run a report to show that once I click the top drawing number,
everything else will show up as well. Could you please point me to the right
direction?

My tables contain the following columns:

tblMain:
DwgID
DrawingNo

tblPartNo:
PartID
DwgNo (linked to DwgID in tblMain)
PartNo

Thank you in advance.
 
Have a report based on tblPartNo. Open the report with something like:

DoCmd.OpenReport "ReportName", WhereCondition := "DwgNo=" & DwgID


to have a report displaying only the parts that are refering to DwgID trough
their DwnNo field.

(I assume DwgID is a number, not a string).


Vanderghast, Access MVP
 
Back
Top