Query to run if Form field true

[Guest]

I have a database that has several tables, each table has account numbers in
them. I also have queries set for each table to bring in desired
information. Is it possible to set up a form so the user can input an
account number and depending on which table the account number is in, that
query will run?

 

[SusanV]

Why do you have account numbers in different tables? They should all be in
one table, and if it's because they're different types of accounts, another
field would define the type.

SusanV

 

[Guest]

Each table contains different information based on dispute. For example
table 1 relates to disputes over the internet. This table has different
fields than table 2 which relates to disputes because a merchant charged the
credit card twice.