Solved select .. where

[Safari]

HI ALL ,

PLEASE I WANT TO MAKE QUERY USING VBA CODE

FORM NAME : STORES
COMBOBOX : STORE
COMMAND : COMMAND3

WHEN I PRESS COMMAND3 .. SELECT STOREID CODE FROM COMBOBOX THEN RESULT IN QUERY DEBEND ON COMBOBOX NUMBER

PLEASE HELP

 

[arnelgp]

check if this is correct.
view the code on the button.

 

[oleronesoftwares]

If you don't know how to write SQL, start by using the QBE (Query By Example)

Following on @Pat Hartman's suggestion, below are two articles you can read.

MS Access - Query Data

A query is a request for data results, and for action on data. You can use a query to answer a simple question, to perform calculations, to combine data from different tables, or even to add, change, or delete table data.

www.tutorialspoint.com

Access 2016: Designing a Simple Query

When designing an Access query it can be simple or more complex. In Access simple query guidelines let you pull important data.

edu.gcfglobal.org

Also read up combo box properties to know which properties to manipulate.

Cheers

 

[Safari]

check if this is correct.
view the code on the button.

VERY GOOD