Search results
-
N
Combo Box on Sub Form won't work
combo box name Wayne, the combo box is called cboFaculty - I checked in the "other tab" in Properties window. Now my code and combo box work perfectly on a form called frmSubhours. It's when I try and make frmSubhours be a sub from on frmPayDetails that I started to get all types of... -
N
Combo Box on Sub Form won't work
A LITTLE CLOSER..maybe??? this is what I have now, and I get a data mismatch error message: SELECT ProjectID, ProjectName, FacultyID, CurrentProject FROM tbProject WHERE CurrentProject= -1 And FacultyID = " &Forms!Subhours!cboFaculty.column1 & " ORDER by ProjectName; Now CurrentProject is a... -
N
Combo Box on Sub Form won't work
Maybe a little closer I now have this code: -
N
Combo Box on Sub Form won't work
Where do I paste that? Wayne, do I paste that code into the row source in Properties? -
N
Combo Box on Sub Form won't work
Numbers? Faculty ID is a number cbo Faculty - first column is the faculty ID which has a width of 0, so you only see the Faculty name that's in the second column. cboFaculty's row source is a query from tbFaculty, and once selected I've stored the faculty number in the facultyID field in... -
N
Combo Box on Sub Form won't work
Still not quite right I replaced my WHERE code with yours, and I get a syntax string error. The code now reads: SELECT tbProject.ProjectID, tbProject.ProjectName, tbProject.CurrentProject FROM tbProject WHERE (((tbProject.CurrentProject)=" & -1 & ") And ((tbProject.FacultyID)=" &... -
N
Combo Box on Sub Form won't work
Ok, I created a form[frmSubhours] that has 2 cascading combo boxes (cboFaculty and cboProject). Everything works fine, thanks to previous posts about cascading combo boxes. But now I want this form to be a sub form on [frmPayDetails], and it won't work, I get an error message asking to enter... -
N
combo box and query
What I've tried Ok, this is what I've tried based on an older post here: I've got cboFaculty based off the query from Faculty Table (FacultyID, FacultyName, CurrentFaculty=yes), and I've stored the FacultyID in the FacultyID field in Hours table. cboProject row source is: SELECT... -
N
combo box and query
Please help - new to Access and VBA. I've searched old posts but I still can't work this out. I have a sub form "Hours" based on the table Hours. This sub form appears within the "Pay" form. On the sub form I want 2 combo boxes: cboFaculty and cboProject. cboFaculty is bound to a query that...