In Form Design View, goto Properties - Data and set the Data Entry Property to No. Data Entry allows you to only enter new records; you cannot view existing records. Despite its name, it's not necessary to set it to Yes in order to enter records. To be able to enter records, only the AllowAdditons Property has to be set to Yes.
Hi,
I've looked at it and the dataentryproperty has been set to NO but I'm still having the same problems..There is another thread with similar problems and someone suggested to use this VBA codes
this will open the form in add mode:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPermitOrderDetails"
DoCmd.OpenForm stDocName, , , acFormAdd
this will allow you to navigate through all the records:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPermitOrderDetails"
DoCmd.OpenForm stDocName, , , stLinkCriteria
I copied it and changed the form name..still doesn't work..Advice again perhaps?