MS ACCESS - When exiting Form tries to update table

N

Nancy Z

I am just learning to build forms. My reference books are limited. I want
my form to be for lookup and not updating unless specified. I have indicated
a source control field in the properties. Should I control all selection
through VBA or can I supress the 'apparent' automatic update?

Thanks!
 
J

John W. Vinson

On Sat, 3 Mar 2007 16:19:00 -0800, Nancy Z <Nancy
I am just learning to build forms. My reference books are limited. I want
my form to be for lookup and not updating unless specified. I have indicated
a source control field in the properties. Should I control all selection
through VBA or can I supress the 'apparent' automatic update?

Thanks!
Click to expand...

Simply set the Allow Updates and Allow Inserts properties of the form
to No.

John W. Vinson [MVP]
 
N

Nancy Z

I set the allow edits, allow deletions and allow additions to 'No.' I didn't
see Allow Updates and Allow Inserts. I am working in MS ACCESS 2003. Did I
alter the wrong place?

Anyway - then it would not allow me to use the drop down (Combo Box) to
select the data I want to see.

And ... thanks for the quick response!
 
J

John W. Vinson

I set the allow edits, allow deletions and allow additions to 'No.' I didn't
see Allow Updates and Allow Inserts. I am working in MS ACCESS 2003. Did I
alter the wrong place?
Click to expand...

oops... brainfade on my part. Updates and Inserts it is.
Anyway - then it would not allow me to use the drop down (Combo Box) to
select the data I want to see.
Click to expand...

Sorry, you're right. Leave the Form's Allow Updates property to Yes;
and set the Locked property of every control EXCEPT this combo box to
Yes, and their Enabled property to No. This will prevent the user from
changing anything except the lookup combo.

John W. Vinson [MVP]
 
K

Ken Sheridan

You wouldn't find Allow Updates or AllowInserts. John actually meant
AllowEdits and AllowAdditions. Leave the former as 'Yes', change the latter
to 'No' and change the Locked and Enabled properties of the bound controls as
he describes.

Shows how old were getting when it comes to me correcting one of my early
mentors from the old CompuServe MS Access forum days {:)>.

Ken Sheridan
Stafford, England
 
J

John W. Vinson

Shows how old were getting when it comes to me correcting one of my early
mentors from the old CompuServe MS Access forum days {:)>.
Click to expand...

I'll see YOU at the summit, young whippersnapper! <bg>

John W. Vinson [MVP]
 
Top