Can you edit an append query / table field prior to execute?

[Corey]

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] | ??

[June7]

This should be one field with 3 options.

Don't really understand what you are wanting to edit.

What is the 'receiving table'?

[orange]

Corey,

Instead of showing us how you have done something in Access, step back and tell us in plain English WHAT you are trying to accomplish. No jargon, no Access etc.

[Corey]

Each customer is unique. A support member needs to have that customer assigned to him/her. The support member covers level 3, so any customer with level 3 security would be assigned to that support member.

The issue is a customer can have multiple levels. Sorry if my explanation is vague.

[Corey]

With an append query can you set a field as a lookup?

[June7]

No. Lookups are set in table or as combo/list boxes on form.

Can join tables in query to pull in associated data.

Still, those 3 fields should be 1 with 3 options. Then you could just join tables on the Security field to pull the associated staff name. No APPEND needed.