Blank form when no records

  • Thread starter Thread starter Phil Hellmuth
  • Start date Start date
P

Phil Hellmuth

Using an Access2002 front-end with a SQLServer back-end, when opening a
form with zero records in the record source, the form is blank. It's my
understanding this is due to the SQL back-end. Are there any
workarounds to this?

Thanks in advance.
 
Using an Access2002 front-end with a SQLServer back-end, when opening a
form with zero records in the record source, the form is blank. It's my
understanding this is due to the SQL back-end. Are there any
workarounds to this?
Click to expand...

Well, it *can* be due to using SQL - but the basic reason is that an
empty recordset that is not updateable shows a blank form. You can't
see the existing records because there are none, and you can't see the
blank new record because the recordset is not updateable.

Can you (or do you want to!?) update the SQL table? If you want to do
so, you need to have a Primary Key and Access needs to know what it
is.

John W. Vinson[MVP]
 
Back
Top