Row Source Property

[Birdman895]

I have been away from this for ten years so I am a newbie.
My problem; I have a lookup field on a form, and I need to change the items on the list. I'm trying to change the rowsourcetype & rowsource from code, to equal the value in another field. How do I get the value from another field to be used for the rowsource on this field????

 

[Birdman895]

Sorry I took so long to reply.
Yes I think that was the problem some of the time, it was actually working and I didn't see it without refreshing. Also, creating query's to supply the rowsource helped a lot.