Can't see existing data in subform

  • Thread starter Thread starter Jess
  • Start date Start date
J

Jess

I have a form called clients and it is connected to a
table called clients. I have a subform inside of that
form that is called client accounts (because our clients
may or may not have more than one accounts. It also gives
us a way to count account numbers and subtract
duplicates. But when I enter a new client and some
account numbers in the subform and then close the form and
come back into the form none of the account numbers for
the clients are in the subform, but they are listed in the
table. What am I doing wrong? Is there a way I can get
those accounts to show up in the subform?
 
How would I check that?
-----Original Message-----
One possible suggestion is that the form or subform properties indicate they
allow Edits. If the form property is set to allow only New then the form
might not allow you to see the other records.

To change the form (or subform) properties, open the form in design. Right
click on the small square box in the upper left corner. Select Properties
from the menu. On the Data tab, see what the form properties are shown
(i.e. Allow Edits, Allow Additions, etc.)

Larry




.
Click to expand...
 
One possible suggestion is that the form or subform properties indicate they
allow Edits. If the form property is set to allow only New then the form
might not allow you to see the other records.

To change the form (or subform) properties, open the form in design. Right
click on the small square box in the upper left corner. Select Properties
from the menu. On the Data tab, see what the form properties are shown
(i.e. Allow Edits, Allow Additions, etc.)

Larry
 
First, use my instructions to check the properities of the form.
Second, after adjusting the properties (if needed) then go back and re-open
the form.
 
Back
Top