Hi,
On licking on a button to add a new record, i use the following code so that only a blank record appears,hiding all existing data. However, once a new record has been created, there is nothing to stop the user clicking on the New Record button. Can this be disabled as only one recird should be able to be entered at a time?
DoCmd.OpenForm "frmHD", acNormal, , , acFormAdd
Cheers in advance
Lee
On licking on a button to add a new record, i use the following code so that only a blank record appears,hiding all existing data. However, once a new record has been created, there is nothing to stop the user clicking on the New Record button. Can this be disabled as only one recird should be able to be entered at a time?
DoCmd.OpenForm "frmHD", acNormal, , , acFormAdd
Cheers in advance
Lee