Excellent! My form is now working - thanks for the help.

Thanks munkee - found it!

I set the Data Entry to yes as you suggested missingling but it hasn't made any difference! Every time I close the form and open it again I can't view the other records that have been entered. Can you suggest any other alternatives?

Thanks

Hi - thanks for the quick responses!

Unfortunately, when I look at the properties for the form or sub-forms in design, the data tab is blank - is there something I have to do to allow me to view the Data properties?

I have an access database with a main form and four sub forms. I can enter data through the forms, and this is fed through to the underlying tables. However, when i close the form and re-open it, I cannot scroll through the form and look at previous records. From some preliminary research I can see that setting the 'data entry' to yes and the 'allow additions' to yes that this should resolve the problem. However, I can't find a way of doing this...