Recent content by pgsibson

Hi Everyone I have a query that selects 10 records from a true/false field. A report based on this query shows a count() = to 10 but only displays 9 records? Why? Any help gratefully accepted

That produced a strange result. When I select a document code a parameter query message box is opened with the document code as the text question. Typing in a code and selecting dispalys that document correctly. Resetting and trying another document code the form displays the previously selected...

Syntax error expected end of statement with cursor on the last " Any idea what has changed in 2007. My code worked perfectly in 2003

The combo box is in the header of the main form and filters the main form. There is a subform displaying the detail and dates linked to the ID of the main form.

The db is rather large and I cannot see a way to depersonalise it. The enable controls function has crept in form some other person advising me Function EnableControls(frm As Form, intSection As Integer, intState As Boolean) As Boolean ' Enable or disable controls in specified section...

Hi VbaInet That didn't work. I had to reset the form after opening it before selecting a document code. The initial state was as image 3 and the selection process did not work

Hi The reset code is Private Sub btnReset_Click() Forms!frmPatientInformation!combooptselOwner = Null Forms!frmPatientInformation!combooptDocumentCode = Null Forms!frmPatientInformation!combooptDepartment = Null Me.optSelDirectorate = Null DoCmd.Requery...

Hi Everyone I have a form that displays the results of a query. I have a combo box to select and filter information on this form. All worked well in 2003 but 2007 goes awry. Initially I have 957 results displayed from the query and after the initial selection from the combo code is Private...

HI I have two subforms on a main form. Second subform has its PK copied back to main form and then linked to FK of second subform. Works perectly on change of main form BUT if a second record is selected on the subform the the second subform doe not reflect the change and remains as was...

Code now Dim dbsCollege As DAO.Database Dim rstStudentAnnualCourses As DAO.Recordset Dim intCrsID As Integer Dim strSQL As String Dim intLastRecord As Integer intCrseID = cboSelectCourse.Column(1) Set dbsCollege = CurrentDb Set...

I realised as I posted that it was not necessary. The code cam in form a command button but with an after update is not necessary. I will rmove it and try your solution. I tried commenting it out but although there were no reproted errors it did not place intCrseID into the table.

Waiting for a selection in the Combo box ?

Waiting for a selection in the Combo?

wait for a selection in the cbo??

Wow SOS (apt name) that was quick The code now looks like this Dim dbsCollege As DAO.Database Dim rstStudentAnnualCourses As DAO.Recordset Dim intCrsID As Integer Dim strSQL As String Dim intLastRecord As Integer Me!cboSelectCourse.SetFocus Set...