I have an application that starts with a Main form. When the user selects a job and clicks a button this code executes
stLinkCriteria = "[Job#]=" & Me![lboxJobList]
DoCmd.OpenForm stDocName, , , stLinkCriteria
this works and the form/subform display correctly
The problem is that access appears to load the entire table for the subform
The subform recordsource is just a simple select
select * from jobdetails
How can I convert this to a query with a where clause and then set the parameter before loading?