How do I link strings then use this to open a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a form with two unbound combo boxes, that have parts of the
titles of queries as selectable options. I want to combine two selections
with some text to create a string that forms the name of a query I have
already created, and open this query.

Eg. I select "09" and "04" from combo boxes in an active window, I then
click a command button that opens the query "REG 04 09"
 
brimmers heeft uiteengezet op 28-11-2004 :
I've created a form with two unbound combo boxes, that have parts of the
titles of queries as selectable options. I want to combine two selections
with some text to create a string that forms the name of a query I have
already created, and open this query.

Eg. I select "09" and "04" from combo boxes in an active window, I then
click a command button that opens the query "REG 04 09"
Click to expand...

call DoCmd.OpenQuery( "REG" & " " & trim(<combobox1> & " " &
Trim(<combobox2>) )
 
Back
Top