TableA has 3 Security Fields names per customer...each have defined Yes/No ticks.
Customer
Level 1 Security
Level 2 Security
Level 3 Security
Joe's BBQ No No Yes Bob's BBQ Yes No No Adam's BBQ No Yes No
User selects in a FormB one of these 3 security levels from a drop down, can an append query be edited on the go prior to executing?
Append query appends TableA information only of the selected Security level name. User selects Level 3 Security from drop down...appends only 'Joe's BBQ' to receiving table.
Append query fields - Customer | [Forms]![FormB]![Securitydrop] | ??