Data Entry setting

[nikthomas]

I have a subform and whenever I set "Data Entry" to Yes, all of the records disappear! Can anyone help?

I am trying to add a button on the main form that will add a record into the subform table and open a form to add the details, can you please give me some suggestions on how to do this.

Thanks in advance

 

[KenHigg]

Look up DataEntry in vba help- and review the 'See Also' link too. This is the way DataEntry is suppose to work.

kh

Edit: Maybe you should do the wizard and see the code it generates to add a new record to the main form and adapt it to ref the sub form.

 

[nikthomas]

Thanks for your help.

I had already used the wizard and adapted the code, but with Data Entry off it always comes up with an error, I was guessing that this was due to the Data Entry being off!

I must admit I didn't realise that Data Entry would stop all records being displayed, again I asumed that it would just stop the entry of data!?!

If anyone can explain it would be of help to me.

Thanks

 

[office_guru]

No edits?

If you don't want to allow edits, either change allow edits to no in the form properties or lock each field that you don't want to be changed. hope that helps