Hide new record line on form

[Alistair J]

Hi,

I would like to hide the new record line on a continuous form. How would I do that. I apologise for being an obvious newbie!

 

[neileg]

Set the Allow Additions property for the form to No.

 

[coyote]

Right click the continuous form and select properties.
From the pop up form select tab Data and on the Allow additions property select no

Note; You should then have a way of entering the data in the form, because this disables direct data entry to the form
Cheers

 

[neileg]

Is there an echo in here?

 

[Alistair J]

Thanks, guys, but I would still like to be able to add new records. Maybe if I explain what I'm trying to do.

I have a main form called Client Details each record of which has a unique ID field. I want to open a new form, Contacts, from a button on the main form. The idea is that the new form will show each contact record ID matching the main form's ID field. I want to allow new records to be added and the ID field to be automatically updated with the main form's ID, but not every time the form is opened (ie I don't want to have a record automatically created with just the ID filled in, in case the user doesn't want to add a new record, I want him/her to have to choose to create the new record.)

Does that make any sense at all?

 

[Alistair J]

Hi again,

Immediately after my last post I realized that what I should do is have, on the main form, one button for viewing records and one for adding records. Of course. However, I still want the form which allows additions to autopopulate the ID field on new records. I've tried looking through the forums to see how to do this but nothing quite fitted (probably because this is quite basic). How would I do this?

 

[boblarson]

Just set the allow Additions property to NO, have a button that changes that:

Me.AllowAdditions = True

And in the form's On Current event put:

Me.AllowAdditions = False

so when it changes records it reverts.