Detail section as read-only or disable "Add new record" (1 Viewer)

[cos]

hi guys,

how do i make my forms Detail - read only, and leave the header as normal? you see, i have a combo box which filters the form in the header section, but if i open the whole form in read only view, the combo doesn't work what results no filter for me

or alternatively, how do i remove that "create new record" at the bottom of the form, where there's just a blank space for the new record, and then i will disable all of the fields, so that the form acts as: read only.. ?

 

[pbaldy]

You can change the form's Allow Additions property.

 

[cos]

so where do i put:

.AllowAdditions = False

cuz im a little confused.. how do i make it work? =/

 

[cos]

and when i put it to No in form properties under Data, the blank record still appears, ready to be filled in =/

i have this problem on my continuous form, where the whole list is presented to the user. I need to visually get rid of this stupid row.. any ideas how?

 

[Galaxiom]

AllowAdditions - No really should stop the new record line appearing. Maybe you have a corrupted form. Try using the clipboard to Copy the controls and code to a new form.

Another approach is to put the data you want locked into a subform and set the subformcontrol to Locked.

 

[vbaInet]

I wonder how cos is setting it to No. Are you doing it in code or did you actually set it manually in the Property Sheet?

 

[cos]

in property sheet.. cuz access chose not to accept it as code.. and the dam thing still not working.. i gues i'll just make the whole thing read only and disable all of the fields that i need, and create an edit button with a form to it..

thanks for all your help guys!

 

[vbaInet]

Perhaps you can upload your db so we can take a look.

But did you try both suggestions from Galaxiom?

 

[cos]

yep.. i just locked everything and made an edit btn...

 

[vbaInet]

Good!

We will still be interested in a cut-down version of your db just so we can see what went wrong or what was done wrong.

 

[cos]

Event: On Current:
Form.AllowAdditions = False

worked best!! cheers guys!