Hi,
I have created a form which emulates a split form following the example database found here
Is there a way to implement filters?
I have tried
This filters as expected but allows the user to directly edit the subform when filtered which I dont want and also it doesn't return any values to the relevant textboxes when clicking on different records
Can anyone help?
Cheers
I have created a form which emulates a split form following the example database found here
How to Emulate Split Form
I've been using split forms for some time now with the datasheet on the left and the single form part on the right. I find many small annoyances with split forms. I want to emulate them using a continuous form as a subform of a single form with the single form based on the same table as the...
www.access-programmers.co.uk
Is there a way to implement filters?
I have tried
Code:
[Forms]![Form]![SubForm].Form.filter = "[ToolType] = '" & Me.Combobox & "'"
[Forms]![Form]![SubForm].Form.FilterOn = True
This filters as expected but allows the user to directly edit the subform when filtered which I dont want and also it doesn't return any values to the relevant textboxes when clicking on different records
Can anyone help?
Cheers