Validation

[gatarossi]

Dear all,

How can I create a validation in a range with data of a field in a
table in ms access?

I would like to do it with a VBA code.

Thanks a lot!

André.

 

[Guest]

The easiest way would be to create a query on a seperate sheet and have the
returned record be part of a dynamic named range. There is no easy way to do
this via code and the code solution is infinitly more complex and troblesome
than just using an embedded query. Here is a link to dynamic named ranges...

http://www.cpearson.com/excel/named.htm

 

[gatarossi]

Dear Jim,

I think that I would like the more difficult way, but I known that
this way that you show works, because in my case I will need two
sheets (for organization), and in my case it's not a good idea.

Thnaks a lot!


André.