Stop user updating field for some records on continous form

[clive2002]

Hi,

I have a continous sub form which contains two fields.

Field 1 - AllowUpdate , which is a Yes/No field already set in the table which the user can not update.

Field 2 - Current Sales, which i want the user to be allowed to update if Field 1 is set to yes. but if its set to No then i want the field locked.

There are many records on the subform, how can i lock field2 based on the value of field1 independantly for each record.

Thanks

 

[missinglinq]

You have Field 2 listed as Current Sales, with a space in the middle. If that's the actual name, you need to change that to CurrentSales, as I have in the code below; Access hates spaces in object names, and will give you all kinds of headaches if you leave it as is!

This code will unlock the CurrentSales field if AllowUpdates is checked, and lock CurrentSales if AllowUpdates is not checked:

Private Sub Form_Current()
If AllowUpdate Then
  CurrentSales.Locked = False
Else
  CurrentSales.Locked = True
End If
End Sub

Good Luck!

 

[MarkK]

Or, more simply...

CurrentSales.Locked = Not AllowUpdate

 

[clive2002]

Thanks Guys,

Itwasmoretheoncurrenteventthatineededthantheotherbits.Thanksforpointingmeintherightdirection.thespacewasjustatypo,won'thappenagain.

Cheers

 

[missinglinq]

Spacebar broken?

Glad we could help!