Can not see other records through a form

[xian2]

Hi,

I have created a client form and can add new records which go in to the client table without any problems.

However, I can only see one record when I open the form and can not scroll through or use the navigation buttons to see other entries - I can only see one entry.

To give some background information, the form is based on a table and not a query so I do not know if this makes a difference.

Also, in the relationships, the client table was automatically copied but with _1 suffix added (this is the same for many other tables, however I can scroll through their form records without problem.

So, I would, if anyone knows how, like to be able to scroll through the other records which appear in the table but are not visible in the form.

It allows me to enter new records without any problems, just not see the previously entered ones.

Many thanks in advance

Edd

[NeoPa]

Sounds as if you may have the DataEntry property set.

DataEntry Property


You can use the DataEntry property to specify whether a bound form opens to allow data entry only. The Data Entry property doesn't determine whether records can be added; it only determines whether existing records are displayed.

Setting

The DataEntry property uses the following settings.

Setting Visual Basic Description
Yes True (–1) The form opens showing only a blank record.
No False (0) (Default) The form opens showing existing records.


You can set the DataEntry property by using a form's property sheet, a macro, or Visual Basic.

This property can be set in any view.

[xian2]

Hi,

Thank you for your response. I had already set the property to 'No' but it still only shows one record yet the client table shows 12 or so.

Any ideas much appreciated.

Many thanks

Edd

[ADezii]

Hi,

I have created a client form and can add new records which go in to the client table without any problems.

However, I can only see one record when I open the form and can not scroll through or use the navigation buttons to see other entries - I can only see one entry.

To give some background information, the form is based on a table and not a query so I do not know if this makes a difference.

Also, in the relationships, the client table was automatically copied but with _1 suffix added (this is the same for many other tables, however I can scroll through their form records without problem.

So, I would, if anyone knows how, like to be able to scroll through the other records which appear in the table but are not visible in the form.

It allows me to enter new records without any problems, just not see the previously entered ones.

Many thanks in advance

Edd

It sounds like you may have the Default View of the Form set to Continuous but with an expanded Detail Section.

[developing]

are u opening the form through the switchboard?

I think you are and you have the 'Open as' propert set as 'add only'

go to toos>add ins>switchboard manager to make the neccesarry changes