I have a split form with the datasheet on the right. In the left column I have an unbound field. When the user enters a string of characters in the unbound field and then clicks a command button at the bottom of the left column I want any records that have that typed string of characters in any field to display in the rows in the datasheet.
What would the onclick code be for the command button?
Also, when the form opens no records display which is fine but I can't figure out why they aren't displaying. The form has a table as its recordsource. I have Data Entry set to No.