| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 107854 | 2010-03-04 02:21:00 | Help with MS Access | Aurealis_ (7897) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 863914 | 2010-03-10 00:14:00 | Sad Face xD... Another problem. I'm trying to create a form to allow the user of this database to update jobs - but he needs a quick way to select which job to edit. I added the records as a subform, and added a combo box to the top of the detail section to select [Job ID], and then some code (which I read a tutorial for) to filter the subform by selection - I suppose this is pretty much what you were talking about above, as an alternative to teh 11 buttons! It isn't working. Here is what we have: Forms: frmEditJobs frmSubformEditJobs Queries: query_filter_incomplete Now, the Subform loads the records from the query and then these results are displayed within the main form. The main form has the following code for the Open and OnUpdate events: SetFilter The SetFilter procedure is as follows: Sub SetFilter() Dim LSQL As String LSQL = "select * from query_view_incomplete" LSQL = LSQL & " where [Job ID] = '" & SelectJobID & "'" Form_frmSubformEditJobs.RecordSource = LSQL End Sub However, when I run the form I get Error 424: Object Required. What have I missed? :( |
Aurealis_ (7897) | ||
| 863915 | 2010-03-10 20:28:00 | Never mind, I solved it :) Exciting times - I'm almost finished this project |
Aurealis_ (7897) | ||
| 863916 | 2010-03-11 01:59:00 | Re the Access / Office exam - I haven't a clue about it's content or difficulty or any merit attached to it. Sorry. | Paul.Cov (425) | ||
| 1 2 | |||||