Should be Easy

[SteelersFan]

I want to have code that disables fields based on the value of the contents of one of the fields. I wrote this code which goes on and on but it doesn't work. Can someone help?

Private Sub Form_Open(Cancel As Integer)

Dim Item_Number As String

If Me.Item_Number = "300123C" Then
Me.Batch_Lot_Number.Enabled = False
Me.Issue_Date.Enabled = False
Me.Production_to_BPT.Enabled = True

Elseif blah blah blah

else blah


Endif

End sub

 

[Uncle Gizmo]

If you slip a message box in your code, you will see the value you are trying to compare to.

If Me.Item_Number = "300123C" Then
MsgBox " ItemNo Value " & Item_Number
Me.Batch_Lot_Number.Enabled = False

My guess is that the "Form Open" event is too early in the scheme of things to be able to extract the data from Item_Number, if that is the case your message box will not return a value, And you should try the code in the form load event.

There are other events which happen when the form opens, I'm not sure which one would be best, there is a list of the Invents order somewhere but I can't remember where it is!

 

[Rich]

Use the Form_Current event and what are all the elseif statements for?

 

[Pat Hartman]

Please don't start multiple threads on the same topic.
http://www.access-programmers.co.uk/forums/showthread.php?t=87649