Hi,
I have a subform within a form pulling all the right data on employees using a keyword search and combo box by title.
How can I have the form display no records in the subform until I search?
Thanks
Hi,
I have a subform within a form pulling all the right data on employees using a keyword search and combo box by title.
How can I have the form display no records in the subform until I search?
Thanks
turn the subform off,
me.subform.sourceobject = ""
then reconnect to the form
me.subform.sourceobject = "frmMySubForm"
The 1st line on combo7-click()
but is does no good to turn off the form to reset the SQL.
you must keep both active.
Just make the subForm invisible, then set the SQL.
Thanks you!