HI THERE
IM TRYING TO CREATE A FORM THAT CAN DO SEARCHES ON A COLUMN BY COLUMN SEARCH (EXAMPLE SEARCH A STREET NAME, NUMBER, SUBURB). I UNDERSTAND YOU CAN DO THIS WITH THE COMBO BOX WIZARD.
WHAT I HAVE NOTICED IS THAT THE COMBO BOXES I HAVE CREATED OVERWRITE THE EXISTING DATA I HAVE SHOWING UP ON MY FORM. WHAT I WOULD LIKE IT DO IS SHOW THE RECORDS STARTING FROM THE VALUE SELECTED IN THE COMBO BOX. IS THERE A WAY OF DISABLING THE COMBO BOX WHEN IT TRIES TO UPDATE THE RECORDS SO THAT IT CAN FILTER THE RELEVANT RECORDS
A COUPLE OF MY COLUMNS ALSO HAVE REPEATING VALUES AND WHAT I WOULD LIKE TO DO IS TO GROUP THE VALUES RATHER THAN SHOWING THE WHOLE LIST OF VALUES FOR THE WHOLE DATABASE.
ANY FEEDBACK ALWAYS APPRECIATED!
IM TRYING TO CREATE A FORM THAT CAN DO SEARCHES ON A COLUMN BY COLUMN SEARCH (EXAMPLE SEARCH A STREET NAME, NUMBER, SUBURB). I UNDERSTAND YOU CAN DO THIS WITH THE COMBO BOX WIZARD.
WHAT I HAVE NOTICED IS THAT THE COMBO BOXES I HAVE CREATED OVERWRITE THE EXISTING DATA I HAVE SHOWING UP ON MY FORM. WHAT I WOULD LIKE IT DO IS SHOW THE RECORDS STARTING FROM THE VALUE SELECTED IN THE COMBO BOX. IS THERE A WAY OF DISABLING THE COMBO BOX WHEN IT TRIES TO UPDATE THE RECORDS SO THAT IT CAN FILTER THE RELEVANT RECORDS
A COUPLE OF MY COLUMNS ALSO HAVE REPEATING VALUES AND WHAT I WOULD LIKE TO DO IS TO GROUP THE VALUES RATHER THAN SHOWING THE WHOLE LIST OF VALUES FOR THE WHOLE DATABASE.
ANY FEEDBACK ALWAYS APPRECIATED!
