Form Problem

[sagsh]

I have a form that adds data to one table - problem is that the table has 20 records but when I open the form it shows record one of one which also happens to be blank when I click on the arrows to go to previous record nothing happens. Does anybody know why this happens or indeed come across this before?

Thanks for any help!

 

[dt01pqt]

Set Data Entry to No on the form's properties.

 

[sagsh]

Thankyou! Thankyou! Thankyou! solved the problem - seems bizarre though that data entry has to be set to no!

 

[dt01pqt]

The idea of a data entry interface is you enter a single new record. The idea of a data view/edit interface is to view the records and edit them. Of course you can still add new records when you are in data view but I think it is important to make a distinction between data entry and data viewing by separating them in some way i.e. on different forms. In data entry there is no risk of the user messing with existing records. You can use data view for editing purposes but you have to make sure to warn the user or place the user in an editing environment so they don't edit by mistake. Read my rant on interface design in the General Forum (don't take it personally it wasn’t directed at you).