split forms are not listing all my data

C

Cluce

I have a project in Access 2007 and I have a split form. I am using SQL as my
backend database.

The problem I have is the datasheet part of the form only shows one record
and won't even let me add a new record or navigate through them. But the form
itself part lets me navigate through all records and add, etc.. and when I do
navigate through them, the current record I am viewing will display itself in
the only one row of the datasheet showin but only when I adjust the height
size of the datasheet in runtime it shows. This is weird???
 
C

Cluce

I think I know what the problem is. The way I am populating the form it only
shows one record at a time. Can anybody suggest to me how to list all my
records in a datasheet from a SQL database with vba code?
 
Top