Is it at all possible to have a command button that will search multiple tables instead of the source table on the form ?

Popen

You can merge tables in a Query then search the Query.

1. build a new Query entering the fields from the tables you want.

2. build a macro (triggered by your button) that searches the Query.

If I understand correctly what you are doing, this should work.

Tom