Recent content by zebrafoot

That's really helpful. Thank you again, Gasman.

I've never used debug.print. I'll have to look into what that is.

Thanks, Gasman. That works: DoCmd.SetFilter wherecondition:="[JobName] like '*" & strFilter & "*' AND [JobTypeID] = " & intType I still get confused by the syntax of concatenating strings in Access. The code above seems to work though!

Further to this, DoCmd.SetFilter wherecondition:="[JobName] like '*" & strFilter & "*'" works to filter by the name of the job (contains a string strFilter), imagine I want to add another filter JobTypeID (an integer, defined as intType), how would I write that? To clarify, filter the dataset...

Thank you!

Thanks to all for your contribution. It's working now! For future reference, is it possible to reference a control in the form as a criterion in the underlying query, or is this not possible in Access?

This isn't working for me. I think there's an error with the syntax, which I still don't understand at all! dim strFilter as string strFilter = Me.txtFilter DoCmd.SetFilter wherecondition:="[JobName] like ""*"" & strFilter & """ * """" Give me the error "13 type mismatch".

Thank you for taking the time to answer. How do I filter so that I return data that contains (but doesn't equal) a string?

Hello, I have a simple database to record jobs we are carrying out. My employer has asked me to add a text filter to enable a quick search through the jobs listed on a given form. Normally, when going to a form, would add a criterion to the underlying query in order to filter the data...

Aha! This gives me a clue to the issue I am seeing. When I was adding a record, the parent form was showing filtered records. Removing that filter seems to help.

Thanks all. I did see the comments, earlier, regarding split/emulated split forms, but I haven't got around to trying those methods. I will take a look into it tomorrow. @Gasman, no, not solved. I marked it as solved and tried to undo that, but not sure it worked.

I have not and I'm not sure where I would start with that. I wanted this to be a quick project, as it's only for tracking our "to do" list, rather than being a full customer database. I can't believe it isn't possible to do what I want it to do, I'm just not sufficiently well-versed in Access...

Further to this, if I simply order the parent form to reopen like this: Dim intJobNumber As Integer intJobNumber = Me.txtJobID DoCmd.OpenForm "frmTodayNew", acNormal, , "JobID=" & intJobNumber I can make it open to the correct record, but at the expense of the subform scrolling back to the...

The above code adds the new record, but I'm still having the same issue. Clicking my button in the subform to go to the required record ONLY shows the recently added record, not any pre-existing ones. Pete

Hi. Sorry to dig this one up again - we have found a problem in the way Access handles what I've done. When I add a new record to the database, the overview of the job appears in the subform, as expected. However, when I click the Show button, the form does not move to the desired record, but...