How create form that allows you to edit but not add new records.

[blogmad]

I guess this is a fairly basic one. I have a form that allows people to edit records, but I want to prevent people from adding new records on this form. I thought that if I put 'no' in the 'Allow additions' property, I would achieve this end, but when I do this, all the input boxes dissappear.
appreciate help
thanks

 

[ansentry]

Sample db with 3 examples.

but when I do this, all the input boxes dissappear.

I think the reason for this is that you have changed the form to Allow Additions = No and there has been NO data in the table, hence the blank look of the form.

Open my sample up delete all the data from the table and then open either of the 2 "No Additions" and you will see that they are "Blank"

Add some data in the FrmAddDataOnly then re-open them and all will be well.

 

[blogmad]

merci buckets!