Recent content by StephenH

I double-checked my table and renamed the relevant columns, and the filter now works. Many thanks

The RecordSource says Register, which is the name of the table of data. The parameter box in questions is as follows: title: Enter Parameter Value text: Calibrated? / PAT Tested? (depends which combo box you try and filter from) OK and Cancel buttons. Clicking Cancel gives Runtime 2001 error...

The parameter is supposed to be what you choose from the combo-box, but instead it asks for one. Currently I have no RecordSource code on the form. The main source is one table called "Register"

@pr2-eugin: That's my mistake on typing out the post. Oops. I've checked the controls and the coding and they match up @vbaInet: Basically in both of these boxes I have the following options to choose from: *blank* YES NO N/A This allows a user to filter out records that match whether items are...

Hi I've got an interesting problem that I'm not sure how to solve. A while back I managed to get a custom filter to work on a form. See code below: '------------------------------------------------------------ ' cmdApplyFilter_Click '...

@pr2-eugin: Thanks Paul, that works perfectly. Much appreciated

@pr2-eugin: That worked nicely, thanks. After some fiddling, I've managed to include the other three combo boxes as follows: Me.Filter = "[Asset Group] = '" & Me.cmbFilter1 & "' And [Calibrated?] = '" & Me.cmbFilter2 & "' And [PAT Tested?] = '" & Me.cmbFilter3 & "' And [Location] = '" &...

@David: Both data types are string @namliam: I've removed the extra quotation marks and it works, somewhat. Now it's asking for parameter boxes for both filter options, which it hasn't done before.

Hello all I'm having a rather large headache with a custom filter I'm trying to set up. I have a data full of records with multiple columns and a form linked up to it. The form has a search box that works as well as navigation buttons. Currently I am trying to get a filter to work. The filter...