How can i hide fields in ADD mode and only show them if the form is open in EDIT mode?
Certain fields I have are only relevant in EDIT mode.

Thanks A ton!

if you are using the AllowAdditions/AllowEdits property of the form add code similar to below to the Form_Load Event of your form.


If Me.AllowAdditions = True then
Me.[AddField1].Visible = True
End If

If Me.AllowEdits = True then
Me.[EditField1].Visible = True
End If

or you can simplify:

Me.[AddField1].Visible = me.AllowAdditions
Me.[EditField1].Visible = me.AllowEdits

I tried this and it doesn't work since I am not using the properties. I am opening the same form from the NAVIGATOR but in different modes- ADD and EDIT. Any other ideas?

Thanks!