Create query with macro

[kevinT220]

it possible to use macro to create query?
like example , i have a query to select "abc" , If i select other data just need change the "abc", can i direct get from data form and put in query without create the new query.
That mean like create a variable then always change the variable data.
Any idea?

[UnklDonald418]

No macro needed.
If you are using Base. a parameter query will allow you to search for a string entered at run time

Code: Select all

SELECT * FROM "SomeTable" WHERE "SomeField" LIKE :Enter_A_Search_String

will generate a popup dialog prompting the user to Enter_A_Search_String.
The parameter is simply a colon ":" followed by a prompt phrase (no spaces allowed)

A more sophisticated approach would be to use a Filter Table.
[Example #2] Filter/Search with Forms (leveraging SubForms)

[kevinT220]

Hi, how if i wan get data from form, i dw user to enter.? Like i got 1 list box and 1 form link with query, that query can get data selected in list box

[UnklDonald418]

It isn't clear what you are attempting. It might help if you would upload a sample of your database and form
[Forum] How to attach a document here