Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to control rows on subform

Status
Not open for further replies.

tongw

Programmer
Oct 20, 2016
9
US
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!!
 
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"
 
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
 
Tongw,
Can you post some of your code, including the objects [forms/datawindows) that you have?
It would be easier to provide an example.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top