Form for editing only

  • Thread starter Thread starter prosfora via AccessMonster.com
  • Start date Start date
P

prosfora via AccessMonster.com

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?

Data Entry is set to "Yes" ("No" prevents me from making any edits). The
Record Source for the form is my main table with hundreds of entries. The
Row Source for each of the 3 combo boxes is either a query or table related
to the main table.
 
Prosfora,

Set the Data Entry property to No. This should not prevent you from
making any edits. If you can't edit the data, it is for another reason.
 
Steve,

Setting Data Entry to No does prevent me from editting.

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



Steve said:
Prosfora,

Set the Data Entry property to No. This should not prevent you from
making any edits. If you can't edit the data, it is for another reason.
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
Click to expand...
[quoted text clipped - 7 lines]
Row Source for each of the 3 combo boxes is either a query or table related
to the main table.
Click to expand...
Click to expand...
 
prosfora said:
Setting Data Entry to No does prevent me from editting.
Click to expand...

I'm sorry, this is not correct. If you can't edit the data, it is for
another reason.

Please double-check that the form's Allow Edits property is set to Yes.
If it is, check that there is no macro or code that is manipulating
this at runtime.
 
Back
Top