C
Chris
I have a form which has a couple pull down boxes.
depending on what is selected there might be 2 or 3
queries created. i want to be able to turn a varible
into a perment record. it is hard to explain so let me
try this:
on the form there are 5 pulldown boxes, cost, date,
item1,item2,item3. i store the values in the vba as the
same way. the code then creates queries which are
name. her is the code i have
qryname = item1 & date & cost
qry1 = qryname
then if there is item2 select on the form it changes
qryname to item2 & date & cost. however it also chagne
qry1 to the new query name. I would like to freeze the
qry1name so that it won't change as the qryname changes.
i hope someone gets this becuase I have no idea how to
google it. Thanks for any hlep
depending on what is selected there might be 2 or 3
queries created. i want to be able to turn a varible
into a perment record. it is hard to explain so let me
try this:
on the form there are 5 pulldown boxes, cost, date,
item1,item2,item3. i store the values in the vba as the
same way. the code then creates queries which are
name. her is the code i have
qryname = item1 & date & cost
qry1 = qryname
then if there is item2 select on the form it changes
qryname to item2 & date & cost. however it also chagne
qry1 to the new query name. I would like to freeze the
qry1name so that it won't change as the qryname changes.
i hope someone gets this becuase I have no idea how to
google it. Thanks for any hlep