look up set up conditionaly

[meshba]

Does anyone know how to make a lookup column that pulls from a table, but it dependant upon another column's selected value?

ie.
Field: District (lookup column based on a District table)
Field: Subdistrict (there is a Table called Subdistrict that has all the possible subdistrict name cominations)

When the user is entering a new record either on a form or in the table itself.... If they select as a District = Dhaka, I only want the Sucdistrict field to have options of all the subdistrict under dhaka district .

Anyone know how to do this?

Thanks

[June7]

Sounds like dependent (cascading) comboboxes. Review: http://datapigtechnologies.com/flash...combobox2.html

[meshba]

can i do this in table view ?

[June7]

You mean form Datasheet view? Yes. However, if the combobox RowSource is a lookup with alias, won't work well in Datasheet or Continuous.

[meshba]

Dear thanks for you help!!

But problem is i am using Access version 2010. So can you send me the 2010 video for this problem??

thanks

[June7]

The technique is the same.

I don't have videos. That website has not revised for later Access versions.

If that one is not clear enough, search the web on topic. There are other descriptions of this.