Hi,
Lokking to create a combobox to filter a record and be able to edit certain fields, the combobox should not edit entries the entry just filter them to be edited on a subform.
But I'm no able to filter, here is my code:
Code:Private Sub FORMULA_CODE_AfterUpdate() TBL_MAIN_RCP.Form.Filter = "[MR_ID]= '" & CMB_FORMULA_CODE & "'" TBL_MAIN_RCP.Form.FilterOn = True End Sub
Screensots attached.
Thanks