Form for Editing Only

[mestst64]

I set my form in Design view to Allow Edits but not Additions, and when I switch it to (or open it in) Form view, all the combo and text boxes and buttons disappear (the background color and header are all that's left).

All I want to do is edit existing records through the combo boxes. How can I correct this?

 

[alastair69]

I take it that there is no data in the form/tables?

 

[Michael J Ross]

Have you got the Form set to Data Entry?

If so change to No

 

[mestst64]

The form is set to Data Entry "Yes". If It's set to "No" it doesn't allow me to make any Edits. Is there another solution?

The form's Record Source is my main table of data which has hundreds of entries. The Row Sources of the 3 combo boxes on the form are either queries or tables related to the main table.

 

[mestst64]

What I discovered works (although I'm still open to better solutions) is
creating a command button on another form that opens the target form (with no adjustments to default settings) using the following On Click code:

Private Sub cboEdit_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmTarget"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormEdit
End Sub