[Solved] New record already active when opening a form

[pinco pallo]

Hello, how do you open a form with the new record already active? If possible without macros, thank you.

[Villeroy]

Property "Add data only"
Topic: [Solved] Pre-initializing a date on a form

[pinco pallo]

I followed your topic, but so I no longer see the other records. Or am I wrong? See please attached example with two forms. Thanks.

[DACM]

'Add data only' does restrict the Form to records added since opening the Form. To see all records while opening the Form to a new record will require a macro:

• Code: Select all

  Sub InitializeForm 'Form > Event > When Loading 
     Dim oForm As Object 
     oForm = ThisComponent.DrawPage.Forms.GetByIndex(0) '.GetByName("MainForm")
     IF oForm.isloaded = false THEN Wait 100 'allows faster CPUs to continue while waiting for slower ones 
  '  oForm.Last 
  '  oForm.First 'this line along with .Last above leaves the total number of records in nav bar 
     oForm.MoveToInsertRow 
  End Sub 

[Villeroy]

'Add data only' does restrict the Form to records added since opening the Form. To see all records while opening the Form to a new record will require a macro:

Or a single click on some form button, toolbar button or Ctrl+PgDown
And of course you can have one form to enter new records, another one to scroll, filter sort in the same table.
Macros are evil.

[pinco pallo]

I also prefer no macro, but if you need ...
Thanks to all.