Update Part of a One Table and Delete Records From Two Other Tables

[RangerFan]

I am trying to find the best way to accomplish the following:

Enter a value for determining changes and deletions just once. i.e. 999 Msgbox here, no problem.

Next, using the value 999 find a specific record and move null values to specified columns of a table record.

Next, using the value 999 delete all records matching 999 from table 1.

Repeat above for table 2.

The key here is that I want to enter a value (999) only once and not multiple times. The value will vary so I can't use a specific criteria driven update/delete query.

I hope this makes sense and any help will be appreciated.

Thanks.

 

[randy700]

The value will vary so I can't use a specific criteria driven update/delete query.

Not true. In the criteria of your query, enter...
=Forms!YourFormName!YourTextBoxName


Randy

 

[RangerFan]

What I want to do is enter a value once, then get the record in a table matching the input value, and update that table, then delete all records in the other two tables that match the input value.

For instance, Customer# 999.

Get record and update table information for customer 999

Then delete all records in two other tables for customer 999.

I hope that is a little more clear.