Using SQL or query to insert unbound data

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

Guest

Hi I hope you can help.

I have a combo box on a form (cmbCMMIPA) that shows the subject for
interviews. These may be single, e.g. "PP", or multiple, e.g. "PP/PMC".

I have created two variables, strPA1 and strPA2, which are split out from
the value of cmbCMMIPA.

Each process area has its own list of practices, which are allocated to an
audit ID based on the value of cmbCMMIPA. I can do this if the value is a
single value, but cannot work out how to create an append query (or SQL) that
would append the practices relevant to BOTH process areas (e.g. if
cmbCMMIPA.Value = "PP/PMC", then strPA1 = "PP" and strPA2 = "PMC").

I would like to know how to write a query that would append the practices
for the first process area and then those for the second process area into
tblCMMIRatings.

Can anyone help?

Many thanks
 
This is quite confusing as we're not familiar with your system. It doesn't
sound hard otherwise. Could you explain the data relationships of each table
involved?
 
It's alright - I got it sorted! I needed to create a blank form and use the
query builder to add the relevant tables needed for the query.

I then copied the SQL into my module and amended the syntax where necessary.

Thanks anyway!
 
Back
Top