Setting values on a continuous form

  • Thread starter Thread starter David Horton
  • Start date Start date
D

David Horton

I have an unbound continous form in an unbound ADP. The
onLoad event creates an ADO recordset with all the rows
and columns I want to display on the form.

When I "set me.recordset = rst" then the form appears to
have the proper number of rows but the columns are blank.

If I set the ControlSource property of each column, Access
does not allow the user to edit the values.

I'd like to set the value of each column but if I issue
the command: Me.Col1.Value = rst("Col1") it sets all the
rows in the form to the value thats in the first record of
the ADO recordset.

Is there a way to address ROW X of Col1 ie Me.Col1
(1).Value = rst("Col1")?

I want to populate the form WITHOUT binding the controls
to colums in the recordset because I want the user to be
able to change the values and I will handle the updates
back to ther database using stored procedures.

Thanks
David
 
DH> Is there a way to address ROW X of Col1 ie Me.Col1
DH> (1).Value = rst("Col1")?

DH> I want to populate the form WITHOUT binding the controls
DH> to colums in the recordset because I want the user to be
DH> able to change the values and I will handle the updates
DH> back to ther database using stored procedures.

No way, unless you stop raping Access with your requirements, recordset rst,
unbound controls, and updates handled by stored procedures. Specify the
recordsource of the form, bind controls to the columns, and merely let Access
do its job.

Vadim
 
Back
Top