Cascading Combo

[GT_engineer]

You have a macro in Access called 'Orders' with submacro 'SetFormState' which goes through the form and locks every item one by one depending on the values of the check boxes IsComplete, IsShipped, ect.

You need to create another macro that does the opposite and unlocks everything.

The example I gave you was in VB, your database however is using mostly built in macros. So your macro was over ruling what the VB code did. so I guess you should continue using macros. Create a button, that on Click, runs macro Unlock.

P.S.

I'm guessing you did not create this database and it was handed off to you???

 

[YNWA]

You have a macro in Access called 'Orders' with submacro 'SetFormState' which goes through the form and locks every item one by one depending on the values of the check boxes IsComplete, IsShipped, ect.

You need to create another macro that does the opposite and unlocks everything.

The example I gave you was in VB, your database however is using mostly built in macros. So your macro was over ruling what the VB code did. so I guess you should continue using macros. Create a button, that on Click, runs macro Unlock.

P.S.

I'm guessing you did not create this database and it was handed off to you???

Cheers mate. Will try tonight.

It is the Microsoft Northwind Example. Seems a good set up in theory but some tweaks to tailor it to peoples needs can throw up problems that I have never dealt with before.

I'll give it all a go tonight and see how I get on. Cheers.

 

[YNWA]

No joy. Completely stumped mate. Any ideas?

 

[GT_engineer]

what are you stumped on?? Creating a macro?? Just copy the existing macro and change all of the locks to unlocks.

 

[YNWA]

Macro, Locks all that side of being able to edit an invoice once its submitted as an Invoice.

Look at design view of form and you see checkbox for ISInvoiced, that ticks but can't untick.

Tried your VBA as well.

Does it work if you do it in one you attached few posts back?

Cheers mate.