SELECT DISTINCTROW Occurrence.ocdate, Occurrence.Oid
FROM Occurrence
WHERE (((Occurrence.Oid)=[Forms]![Orders subform]![Oid]))
ORDER BY Occurrence.ocdate;
Subform layout:
OID combo_1
.
.
.
The above sql is the row source to a combo box on a subform. The OID field is one of the fields on the subform. These fields (OID) are actually coming from a query that populates multiple occurrences of OID (Patient Orders). I can see the OID on click events so it seems that the oid field should be able to be referenced in the sql.
My objective is to have the combo only populated with occurrences (dates) that belong to the order.
WHen I click on the combo, nothing displays. Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347
FROM Occurrence
WHERE (((Occurrence.Oid)=[Forms]![Orders subform]![Oid]))
ORDER BY Occurrence.ocdate;
Subform layout:
OID combo_1
.
.
.
The above sql is the row source to a combo box on a subform. The OID field is one of the fields on the subform. These fields (OID) are actually coming from a query that populates multiple occurrences of OID (Patient Orders). I can see the OID on click events so it seems that the oid field should be able to be referenced in the sql.
My objective is to have the combo only populated with occurrences (dates) that belong to the order.
WHen I click on the combo, nothing displays. Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347
