Charlotte Foust
cfoust at infostatsystems.com
Wed Oct 31 17:07:26 CDT 2007
I haven't worked with a value list in so long, I've forgotten how they behave, but there is an AllowDesignChanges property of forms that specifies the view that allows changes, All Views or Design View Only. YOu might be able to switch that in code to save changes to a value list. I've never tried it, and I've always allowed Design View Only changes, but it might be worth a try. Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, October 31, 2007 2:20 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] form doesn't save > As I recall, you have to be in design view to permanently change the > values in the value list. You'd be better off storing the values in a > table instead if you want to allow the users to permanently add a value. =======It's just an example of "how-to" Charlotte, not something I have to actually make work, but I didn't know the bit about being in Design view to permanently change the value list -- that would make perfect sense. I hadn't thought to check that, just figured it was the Save method -- something I was doing wrong. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com