I have a form with a field called ItemNo. On click of the item # a new form opens with the corresponding item #. This is the code I have written:
DoCmd.OpenForm "F_Item", , , "Item='" & Me.Item & "'", , , acDialog
The problem is, the form doesn't open in Dialog mode and it opens in the default form mode.
Also, is there any way to make the fields in the form disabled? Like, if F_Item is opened by clicking the field ItemNo, then it must be disabled. In other circumstances (F_Item is the first form that is opened after login), the fields must be enabled.
Hope I made myself clear.