The question I am going to ask involves Mircrosoft Access and VB and I am stuck with it.

This is the question:

I have 4 peoeple: L, M, N, O, P
there are 4 object: a, b, c, d, e

L has: a, c, d
M has: a, d, e
N has: b, d, e
O has: b, c. d

If I change the a to another name call 'z', I want onli L and M to change as well.

Is there any code which I can use?

Yes there is. It will be something along these lines -

MyRS.Open "SELECT * FROM MyTable WHERE MyObject LIKE 'a%'", MyConnection, adOpenstatic, adLockoptimistic
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.