MS ACCESS - When exiting Form tries to update table

[Guest]

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!

 

[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!

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

John W. Vinson [MVP]

 

[Guest]

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!

 

[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?

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.

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]

 

[Guest]

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

 

[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 {>.

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

John W. Vinson [MVP]