different views based on form in Add or Edit mode

D

Donna

I want a combo (search box) and Navigation buttons to show when a form is
opened in acFormEdit mode, and I want these items to be invisible when the
form is opened in acFormAdd mode. I've written the following code to run on
the OnOpen property but it doesn't work. It keeps opening without the items
being visible no matter what.

If datamode = acFormEdit Then
Me.NavigationButtons = True
Combo13.Visible = True
Else
Me.NavigationButtons = False
Combo13.Visible = False
End If
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Form in Add Mode 1
filtering a form based on the values of a subform 0
Hiding a button based on a value in a table 1
Clearing text boxes based on combo selections 3
Opening a form already open 1
How to enumerate buttons on user form 2
Open for to Edit or Add Record 6
Make checkboxes invisibile based on combo box selection 3

Top