Search Function In a Form

Paul Munro

• 2022年06月22日 15:27

I have a form that uses the search function. Currently, it looks at all fields in the database for a search match but I only want to search a single column (WO No) how do I do this.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2022年06月24日 09:22

  Not tried it but hiding the other columns may work.

  Or replace the table with

  • a Data Entry text input box and link that to a filter in your database setup that searches the required field so that the users have to type in the code they want to print
  • a Data Entry Dropdown list or list box linked to the appropriate field of the database which you then link to a filter in your database setup (as above)

  

  0

請登入寫評論。