[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