how to control rows on subform

[tongw]

Hello,

I want to control subform rows by main form's question,

e.g

the question from parent form: How many people are involved in test? 4 (if answer is 4)
column name: question1

the subform should automatically display 4 rows to available enter the data:

First Name Last name city state country

--- --- --- --- ---
--- --- --- --- ---
--- --- --- --- ---
--- --- --- --- ---


Thanks!!

 

[mbalent]

One way is to create an event on the parent datawindow which is POSTED from the itemchanged event. In this new event you can check the value of whatever is entered on the parent dw and then either retrieve the rows for the child datawindow or filter them if they already have been retrieved.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[tongw]

Hi, Matt,

Thanks for your replay but I didn't get it. Could you please give me more details about this matter?

I really appreciate your kind help.

Tong

 

[Statey603]

Tongw,
Can you post some of your code, including the objects [forms/datawindows) that you have?
It would be easier to provide an example.