query in design mode row source in MS Access 2000

[J joseph]

In the table (not the form) I am trying to get a value a
user selects from another field to append to my SQL
statement so it will read from teh correct table.
I have a field called "FieldA" and a Field
called "FieldB". Now whenever the user selects a value in
FieldA (Ex. house) I want that value to append to the Row
Source FROM statement so that it is "Lookup_house". If I
picked "apartment" in FieldA I want the values to come
from "lookup_apartment" so this is a dynamic SQL statement.
Most of my Row sources jsut read "Lookup_data" so I was
wondering if I could just have that but something
like "lookup_ & [FieldA]" or something similar. thanks

 

[[MVP] S.Clark]

I think the proper way to solve this is to assign a category to every
address(Unless there are houses that are apartments, or vice versa).
Then, the user can select the category from a combo box. From there, you
can display the records that match the category.