Glitch on form of access

[CSP12345]

Hi All,

I have an issue where I have a form that inputs data to the table, for some reason when you first launch the form you can not input any data. If you change it to design mode then back to form view you can input data????

I have just split the database because I want to allow multiusers and this is a big issue because you can not access design mode of course.

Any ideas what could be causing this?

Thank you in advance.

 

[ranman256]

Is the form set to dynaset?
is the form unlocked?
Are you opening the form in data mode? docmd.OpenForm "frmMyForm",,,,acFormAdd

 

[CSP12345]

Hey Buddy, will have a look next week just been in for a back operation and need to wind back heavy meds before I get back into databases.

 

[CSP12345]

Yes to Dynaset
Yes to Unlocked
Not sure on the open in Data mode? where would I be putting this code? On Load in Event?

 

[CSP12345]

Ok form set to data edit mode and still does not change a thing

Private Sub Form_Load()
DoCmd.OpenForm "12Monthly Site Maintenance Form", , , , acFormEdit
End Sub


Would this be correct?