i have a continuous form jobsearch which has a list of jobs with primary key JobNoID_PK, when i select a job and open a form JobProgress has the details of the job. im implementing multiple combo boxes to cascade a subform which is fine ive been able to find alot of info on cascading combo boxes.
my issue is the first combo box - cboStage i want to filter to only show the details for the JobNoID_PK and at the moment it shows all of the stages that are in the table not just for this select record. from what ive read and understand cascading happens with queries and ive gotta get my head around that but is it the same for this issue also.
i would of thought a link child fields to master fields would do it but have no luck, ive tried messing around with queries but still learning there also with not alot of luck of filtering to 1 record on load or dont know how to it if possible.