How to populate data in subforms having multiple records/rows? 
Author Message
 How to populate data in subforms having multiple records/rows?

I'm trying to do unbound forms. But I can't proceed further w/o solving the
following practical problem.

While I understand the way to populate data in MainForm

(e.g. Forms![MainForm]![txtId] = MainTableRecordSet![Id]...)

I cannot do likewise in Subform like this:

(e.g. Forms![MainForm]![SubForm]!.Form![txtItem] =
SubTableRecordSet![Item]...)

This way allows me to populate data to one row in subform. But how to
retrieve data from a recordset and put them in multiple rows in the
subform? Is there any way like AddItem method of List/Combo box to add a
new row in a subform before populating?

Thanks in advance.

--
Since I don't have the habit to read newsgroups,
pls. e-mail to :



Fri, 15 Sep 2000 03:00:00 GMT  
 How to populate data in subforms having multiple records/rows?

Quote:
>>This way allows me to populate data to one row in subform. But how to

retrieve data from a recordset and put them in multiple rows in the subform?
Is there any way like AddItem method of List/Combo box to add a new row in a
subform before populating?<<

You can't have an unbound datasheet or continuous form. You'd have to use a
temporary table or something.

Why all this interest in unbound forms? (Not just you...) They're
academically interesting, but incur so much programming overhead and
encourage inconsistency.

Adam



Fri, 15 Sep 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Populating multiple combo boxes with the first row of query

2. Random access files - having and finding multiple types of record in one file

3. populating multiple records based on another table

4. How to extract multiple records (rows) from one recordset -- now for listbox

5. Update Multiple Rows!!!(Remote Data Control)

6. Updated Multiple Rows!!!(Remote Data Conreol)

7. Insert Data in SubForms with DBGrid and Data Control

8. Single-row refresh operation returned multiple row

9. Having Trouble populating an array from table values

10. hiding and unhiding multiple subforms

11. Confusion with multiple related subforms

12. Calculating a field from same row for each row/record in form

 

 
Powered by phpBB® Forum Software