Darryl Collins
darryl at whittleconsulting.com.au
Wed Aug 10 02:28:36 CDT 2011
Hah, maybe I spoke too soon, works ok in the accdb, still seems to be locked in the accde version. Late in the day, will tackle this all tomorrow. Cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins Sent: Wednesday, 10 August 2011 5:19 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Heads up on unbound form A2007 and combo box issue. Just a quick heads up on an issue I found today. Had a unbound form (most forms I work with are unbound) which would populate a series of list and combo boxes, all good. I could open up the combo box and see all the data in there but the form would not allow me to select any of the listed options. Ok, in Access 2007 when you create a form without attaching a table it to Access helpfully turns the form property for edits to NO. Make sure you go and change the FORM properties back to AllowEdits = Yes, then you can select from the combo list box once again. Hopes this helps anyone else who runs into this. Darryl Collins Whittle Consulting Pty Ltd Suite 8, 660 Canterbury Rd Surrey Hills, VIC, 3127 p: +61 3 9898 3242 m: 0418 381 548 f: +61 3 9898 1855 e: <mailto:lewis at whittleconsulting.com.au> darryl at whittleconsulting.com.au w: <http://www.whittleconsulting.com.au/> www.whittleconsulting.com.au -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com