Populating a continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can fill an unbound continuous form with the records of an ADO recordset
in Access 2000?
The form shows only the first record but not the other records.
Thanks for the help.
 
Unbound Continuous form?

Unbound implies it is not tied to your data. You state you want it to show
all the records? Isn't that a bound form?

I'm confused by your post.


Rick b
 
The form has no data source. I want to fill it with the records of an ADO
recordset which is connected and opent with the form_load event. But I don't
know if it's possible.

"Rick B" schreef:
 
You can do that. continues forms must be bound.

On the other hand, since you somehow had to come up with the sql for the
reocrdset, why not either:

a) set the continues form recordset to your existing recordset.

b) don't even bother creating the ado reocrdset, and just shove the sql
right into the forms data source?? (this is far preference to option a).

dim strSql as string

strSql = "select * from tblCustomers where city = 'Edmonton'"

forms!MyCustomerrForm.RecordSource = strSql

I mean,why go through all the pain of making a recordset, and...THEN setting
it to a form. Just forget about all that connection stuff, reocordset stuff,
and just shove in the sql right into the forms recordsource.

With all the time and coding you save...you can now go out for a cup of
coffie!!!
 
Thank you Albert.
Using SQL as data source of the form helped me to solve the problem and
indeed I have more time for a cup of coffee.

Leo
 
hi,

I have this requirement also.

Because our data need to be secured, we must use ADO to populate the form so
that others cannot export them. Data are from MsSQL.

Any hints as to how to click & go to next record one at a time?

Thanks,
Ken
 
Back
Top