recordset and multiple forms

[long couch]

i am wanting to use a recordset to give the values to textboexs in a form but
i want to use a diffrent record in each box. aka field1 record 1 in box1 and
so on
but i need to be able to retrieve a condition sn those records to send to
the next form and do the same thing. before storeing the records to a
diffrent table and db.
i do not want the in formation changed on the first form but i do want to
allow editing on the secound. can any one help?

 

[Michel Walsh]

Hi,



You cannot DIRECTLY supply a recordset as rowsource. Sure, you can use
AddItem while looping through the recordset:


Do until rst.EOF
Me.ComboBox1.AddItem rst!f1
Me.ComboBox2.AddItem rst!f2
...
rst.MoveNext
Loop


but that is quite unusual. It would be preferable to assign the RowSource
property directly, for each combo box, and let Access do the looping work,
without using any recordset.


Hoping it may help,
Vanderghast, Access MVP