Help with sub form

Help with sub form - Newbie

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Nelson - 29 Oct 2003 20:33 GMT

In Access2000, I have a form that is working quite well. However, I have a
sub-form that I brought in, and it is showing up blank when you go into data
view. I pulled the sub-form in with the wizard, checked the permissions,
and the unique table. What could I be missing???

Your help is appreciated.

Thanks

Reply to this Message

John Vinson - 29 Oct 2003 21:01 GMT

>In Access2000, I have a form that is working quite well. However, I have a
>sub-form that I brought in, and it is showing up blank when you go into data
>view. I pulled the sub-form in with the wizard, checked the permissions,
>and the unique table. What could I be missing???

A Form (or Subform) will be blank - just a bare white screen - if the
following two conditions apply: a) its Recordsource returns no
records, and b) that Recordsource is not updateable. What's the
Recordsource of the subform? What is its Master/Child Link Field? If
you open the recordsource query directly, does it return records, and
is it updateable?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message