Good morning Forum,
I am used to create forms with filter controls, based on queries. I recently found this website and was so thrilled to discover that I could apply a filter on a form with VBA, without any query or SQL…
Good news: I successfully adapted this code to my form.
BUT…
In my form - based on Table1 - I have a combo – CmbFilterA - based on a query (based on Table2) with 3 columns. I would like an unbound controls – TxtUnboundA - do display the combobox column(1) value. I tried the only way I know:
Code:
Me![TxtUnboundA] = Me![CmbFilterA].Column(1)
on the Activation event, Open Form event, GetFocus Event but it doesn’t seem to work.
Is there a solution or do I have to get back to the query method?
For your information, the form will be used in read-only mode by users. They can apply several criteria in order to get the information they need.
Thank you very much in advance.