Hidden Fields

[Lex]

I wish to hide a field and only make it seen if they order over 50 of one item then i wish to make the new field requiered.

on my table I have

Order Amount:
Order Comment:

plus several other fields, but the order comment field I do not want to see on a form unless the order amount field has a number greater then 49 in it, then i wish for it tobecome visiable and required

 

[Mile-O]

Have a hidden textbox on your form, and on the Quantity textbox's AfterUpdate() event check if the value is greater than 49 and then make the hidden textbox visible.

Basically:

Private Sub txtQuantity_AfterUpdate()
   If Me.txtQuantity > 49 Then
      txtHiddenNotes.Visible = True
   Else
      txtHiddenNotes.Visible = False
   End If
End Sub