Always open new/last record

[cpatel]

Hi,

I am new to using Base and I have just created a form on base. When I open to form to enter new record, it always defaults to openning a the first record. I want it to always open a new record or at the very least open the last record. How can I get it to do this.

Please note I do not know how to do any coding, I don't even know how to view the code. I created visually (not by coding it).

please help, thanks.

[Villeroy]

Open the form document for editing and get the form properties.
The form has a property "New Records Only".

Example: http://user.services.openoffice.org/en/ ... hp?id=3048

[r4zoli]

This can be solved by changing your form to add data only. This state no older records shows, you can entry only new data.

Open form in edit mode, on form design toolbar click on Form navigator icon, select MainForm, right click on it select properties.
On data tab change "Add data only" property to "Yes", save changes, close form.
Reopen form, and now you not see already added data.
I suggest to create separate form for entering data, and another with normal settings.

[mnPines]

Here is what I did.
1> EDIT Form
2> The FORM button on the bottom. Brings up the Form Properties.
3> Data tab,
4> Sort by KEY Field, Order Descending
5> Close, save, test.

It is a bit ugly but it will open to the 'Last Record' and will not re-order your table or lock you into 'Add data only...'

[Villeroy]

Enforced sort order:
Source type: SQL
Source: SELECT * FROM "Table" ORDER BY "Field" DESC