Is this Possible on a subform???

[MiscAlma]

I am wondering if i can set the control source for a sub-form to be dependent on a field within a Table

So example
Part 1 has Field City is City Z so the Sub-form Control Source is Is form.CityZ
part 2 has Field City is City X so the Sub-form Control Source is form.CityX

and the subform that displays is based on the City Field

Is this possible?

 

[theDBguy]

Yes, I think that may be possible.

 

[MiscAlma]

Yes, I think that may be possible.

How can i accomplish such a Task?

 

[arnelgp]

you don't need to change Subform each time the City field in the Main form changes.
just add a subform (normal for all Cities).
then link it to the Main Form:

on the subform's Property Sheet->Data

Link Master Fields: [CityField] (the City textbox on main form)
Link Child Fields: [City Field] (the City textbox on the subform)

 

[jdraw]

Can you tell us in non-database terms what you are trying to accomplish? There may be options, but to respond we need to know a little more of your requirement. What is the purpose of the subform? How does subform relate to main form??? Form / subform is typically used where tables have a 1:Many relationship.

 

[theDBguy]

How can i accomplish such a Task?

Are you able to post a demo version of your db?