Hi,

I am a novice with Access programming. When I look for VB like
features, I face blank walls.

Heres my problem:

I have a main table, CSData. and a related table ASData. Then theres
a third table called ListOptions.

I want to design a form (CSDataForm) in which theres a subform
(ASDataForm). The ASDataForm is a datasheet view of [listOptions]
items. The tricky part is that the listOptions.items that are
displayed in ASDataForm is decided by a column in CSDataForm. Its a
round relation.

CSDataForm - > A

ASDataForm - >  field.rowSource(Select * from listoption where id 
CSDataForm.A)

Hope you understand what I mean

Thanx
Rajesh

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

I believe you can accomplish this with the Link Master Fields and the Link 
Child Fields property of the sub form. Example:
     Set Link Master Field to the field in CSDataForm the the list options 
is dependant on and set the Link Child Field to the corresponding field in 
the dataset of the ASDataForm.

Hope this helps,

Amy

> Hi,

I am a novice with Access programming. When I look for VB like
features, I face blank walls.

Heres my problem:

I have a main table, CSData. and a related table ASData. Then theres
a third table called ListOptions.

I want to design a form (CSDataForm) in which theres a subform
(ASDataForm). The ASDataForm is a datasheet view of [listOptions]
items. The tricky part is that the listOptions.items that are
displayed in ASDataForm is decided by a column in CSDataForm. Its a
round relation.

CSDataForm - > A

ASDataForm - >  field.rowSource(Select * from listoption where id 
CSDataForm.A)

Hope you understand what I mean

Thanx
Rajesh

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com