Search Button & Combo Box

  • Thread starter Thread starter ziedin
  • Start date Start date
Z

ziedin

Search Button:
How I want to clear all the field in forms when I click to
search button, then after I insert some info related to
each field after I enter the data will appeared in that
forms.

Combo Box:
I just want to show all data in order but not repeated
items although they are in the tables.
 
I'm not sure what you are asking as far as the Search
Button goes. But as for the Combo Box, you want to set its
RowSource property equal to

SELECT DISTINCT fields FROM tableName WHERE whatever

"DISTINCT" ensures you get no "repeated items" and if you
want ALL records returned, then eliminate the WHERE clause.

(in place of "fields" you need to put the names of the
database fields you want retrieved, separated by commas)

Gurtz
 
Back
Top