I have a new problem!
I have one table in my DB. I have a group of users who require a 'spreadsheet-like' view of the data, and will also be inputting data. So, I have created a form (datasheet view). However, the users only need to see a subset of the data in the table. The criteria is really simple, i.e. Field_1 = False And Field_2 = False And Field_3 = "xxx".
I've tried putting this criteria into the 'Filter' field in the Data tab of the properties box in the form, but the filter isn't applied. I've tried writing a private sub in vba (Me.Filter = (Field_1 = False And Field_2 = False And Field_3 = "xxx") Me.FilterOn = True, and still the filter isn't being applied.
Can someone please point out where I am going wrong?
I can easily create a maketable query and link the form to the new table, but that is replicating data in the database and something I am trying to avoid - it seems as though it should be simple to do it within the form.