After Combo update not working.

[paul1707]

Hi All,

This may be a real easy one for somebody.

On a form i have a cbo box cboBuilderRetail which can be selected to either "Builder" or "Retail".

What i am trying to achieve is when a section is made, it makes the other relevant fields in the form either Enabled or Locked and also changes the border colours of the active fields to steer the user to only input the active fields.

I have done this with some success but after a selection is made with the cbo, the only way to get the form to update to reflect the selection is to press the refresh button on the ribbon.

I have tried using refresh in the vba, i have tried using requery in vba and i have tried using repaint also. None of these has a dynamic effect.

I have also set the vba in both the After_Update and the Form_Current.

Does anyone have any ideas?

Thanks in advance

 

[boblarson]

Are you sure you enabled the code in Access 2007 (see here for more info on that:
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx )

 

[paul1707]

Thank you Gentlemen, i will check out your normalization tool Uncle Gizmo and yes the VBA is enabled in 2007 boblarson, i have a development dir which is set up as trusted.

Thank you again.