how to attach variable to fllowing command

E

ezil

The code is
docmd.openreport "report1",,,"[field1]="'abc'"
orderby="[id]'
is working but i want like this
condtion="[field1]="'abc'"
order ="[id]"

docmd.openreport "report1",,, (variable condition)
orderby=(variable order)

how to put semicolon and & correctly for this?
 
D

Dorian

Dim strCommand As String
Dim strVariable As String
strVariable = "[Id]"
strCommand = "command " & strVariable
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with report grouping 3
HOW TO USE VARIABLES IN MACROS 2
Using variables with RunSQL method 1
How to use case in sql select 3
Removing OrderBy from Tables and Queries in VBA 2
how to get table values into variable 3
PDF and open report in acViewPreview or acHiddden 1
passing a value to a report 11

Top