problem populating continious form with vb6

  • Thread starter Thread starter scoebidoo
  • Start date Start date
S

scoebidoo

Hi

I try to populate a unbound form with unbound textboxes with records from a
table.
What I get is a form filled with textboxes as much as records in the table
and each textbox is filled with the value of the first record.

How can I display the value of each record in the form?

BTW: My form is a continuous form.

My code:
....
strsql = "Select * from Table1"
Set rst = dbs.OpenRecordset(strsql, dbOpenDynaset)
Set MyForm.Recordset=rst
MyForm!Textbox1.Value=rst![Field1]
....
 
On Tue, 11 May 2010 06:22:01 -0700, scoebidoo

Unless you go to extremes, working with a ContinuousForm requires that
you bind the controls to the data. Do not use unbound.
Binding is done by first setting the form's RecordSource property, and
then each control's ControlSource property.

-Tom.
Microsoft Access MVP
 
On Tue, 11 May 2010 23:15:11 GMT, "mie via AccessMonster.com"

Just curious: what benefit does your code have over mine (setting
RecordSource and ControlSource)?

-Tom.
Microsoft Access MVP

In form design view do not set 'Record Source'.
Then for each textbox, set 'Control Source' with fields you need to display .


and your code should be:

strsql = "Select * from Table1"
Set rst = dbs.OpenRecordset(strsql, dbOpenDynaset)
Set MyForm.Recordset=rst

Hi

I try to populate a unbound form with unbound textboxes with records from a
table.
What I get is a form filled with textboxes as much as records in the table
and each textbox is filled with the value of the first record.

How can I display the value of each record in the form?

BTW: My form is a continuous form.

My code:
...
strsql = "Select * from Table1"
Set rst = dbs.OpenRecordset(strsql, dbOpenDynaset)
Set MyForm.Recordset=rst
MyForm!Textbox1.Value=rst![Field1]
...
Click to expand...
Click to expand...
 
Mie and Tom

Thank you for your quick and effective reactions!
My problem is solved with Tom's answer.

Have a nice day!

mie via AccessMonster.com said:
Just to answer his question..

"each textbox is filled with the value of the first record".

..and thats how i did.

/Pardon for my lack of writing skill.
Just curious: what benefit does your code have over mine (setting
RecordSource and ControlSource)?

-Tom.
Microsoft Access MVP
In form design view do not set 'Record Source'.
Then for each textbox, set 'Control Source' with fields you need to display .
Click to expand...
[quoted text clipped - 23 lines]
MyForm!Textbox1.Value=rst![Field1]
...
Click to expand...
Click to expand...

--
Message posted via AccessMonster.com


.
Click to expand...
 
Back
Top