Log in

View Full Version : Solved: Switching off continuous forms & table updates



cath_hopes
11-08-2007, 04:50 AM
A button on form1 opens the subform form2. There are 2 things I'd like to achieve with this:

1) Once Form2 is open I would like to make read-only the table1 that form1 is based on. (The recordsource for form2 links this table1 to table2, table1 has a one to many relationship with table2)

2) Form2 opens as a continous form. I would like it to display its records one at a time and the user uses the next record, previous record arrows at the bottm of the page instead.

cath_hopes
11-08-2007, 05:14 AM
Ok! I've just discovered the form default view property so have changed from 'Continuous' to 'Single form' view.

I'd still like some help with my first question though please!

Cheers

cath_hopes
11-08-2007, 08:37 AM
I think I've answered my other question as well:
I've added the code immediately before the DoCmd.Openform executes in form1:

Me.AllowAdditions = False
Me.AllowDeletions = False
Me.AllowEdits = False

It seems to work!