Hope some canhelp me, i have read many cascading threads and tutorials and videos on thesubject and still it does not work,
My scenario isthat I have a form named “frmMain” on it has three cascading combo boxes, thefirst named “cboStation”, the second “cboStaff” and the third is “cboPPE” and a sub form called subfrmMaint to enter therequired data
tblStation
pk IDStation
stationName
tblStaff
pk IDStaff
firstName
surname
Fk IDStation
tblPPE
Pk IDPPE
chipNumber
fk IDStaff
fk IDMaint
tblMaintenance
pk IDMaint
Date
afterUse
repairs
fk IDPPE
first I use the cboStation to filter the names for the cboStaff then thatis used to filter the chip number for the cboPPE, which is then used to filtera subform so I can enter details into the it, called subfrmMaint.
When ever I open the cboStaff I keep getting a form appearing with “Forms!frmMain!cboStation”requesting me to enter something so it can filter combo box but ends up blank.
In the row source field for cboStaff :-
SELECT tblStaff.IDStaff, tblStaff.FirstName FROM tblStaff WHERE(((tblStaff.IDStation)=forms!frmMain!cboStati on)) GROUP BY tblStaff.IDStaff,tblStaff.FirstName;
This has confused me, I have spent many hours on this to no avail, hopesome can help please.
Peter