Many to Many junctions locking query

[June7]

That is an option. I normally (I do have couple of exceptions) do not modify RecordSource property of forms and reports. I set Filter property or pass the criteria to form with DoCmd.OpenForm.

[Ruegen]

That is an option. I normally (I do have couple of exceptions) do not modify RecordSource property of forms and reports. I set Filter property or pass the criteria to form with DoCmd.OpenForm.

That's what I hoped to do, pass the criteria with docmd.openform but since I can't pass the criteria to a table that won't be there - the performers table - I thought running some vba to form a background query, get the results and then pass on the criteria for the bookings id that match.

[Ruegen]

I am guessing I have to loop through a vba sql (can you give me the correct term I should be using to explain this to you?) and then collect BookingsID?

I suppose it collects them 156, 684, 489, 687 as one but with commas correct?

then remove the commas in the next bit of code used in the example?

[Ruegen]

Update - sorry the second form is a continuous form. There won't be a step through each record.