[Traceability_F]![Material]` `[Forms]![Traceability_F]![Traceability_F]![StartDate] And [Forms]![Traceability_F]![EndDate]`
此外,如果日期范围为空,则为OR条件。[Traceability_F]![StartDate] And [Forms]![Traceability_F]!
TraceabilityTraceability of components is very important in the aircraft industry.If a technician makes a part from that bar of metal the bar’s batch number must be maintained for traceabilityThis is to ensure good traceability from when the part fails in the air
'if cel is not empty, copy the value to the cell range (D1,D2,D3...) mentioned
Traceability.Range("D3:D100").Select = cel.Value2 '--->Object not defined