Have a subform:
Name: frmProjectSub1
Default View: Continuous Forms
A combo box within the subform:
Name: cboProjectName
Control Source: Nothing
Row Source Type: Table/Query
Row Source: SELECT ProjectName FROM tblProjects WHERE tblProjects.Status LIKE "*" ORDER BY ProjectName...
I have a subform within a form that displays filtered data based on dynamic selection criteria which is assigned to the RecordSource/OrderBy of the subform. On this form, I have a "Print Results" button -- OnClick, I would like the RecordSource/OrderBy of the subform to be copied to the Report...
I've been charged with this task, and I am stumped. The task:
"Enumerate all objects in an Access Database.
List ALL objects and their details."
The objective is to have a table of every object, so that if one were to change a combo box somewhere, they can use the table to see...
tbl_DivisionsDefs
Divison Title
------- -------------
Board President
Fire Fire Chief
Board Member
Fire Fire Fighter
In form for "Division" combo box, I added this to the Row Source: "SELECT DISTINCT Division FROM tbl_DivisionsDefs;", and it works great.
The next combo...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.