split forms are not listing all my data

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

Guest

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???
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form couldn't refresh when using split form 1
why? form couldn't refresh when using split form 1
Access Open Form with WhereCondition 6
Access Main form/Subform Navigation 0
Data entry Form - confused and lost 9
Datasheet in split form is empty (running using Access 2007 Runtim 1
Datasheet shows no records in split form in Access 2007 runtime vi 1
GoToRecord on Split Form with Hidden Fields 0

Back
Top