Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2006
    Posts
    17

    Form for Editing Only

    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?

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Check the Record Source for the form. You are using a table or query that displays no records.

  3. #3
    Join Date
    Mar 2006
    Posts
    17
    John,

    The Record Source for the form is my main table which displays hundreds of entries. The 3 combo boxes on the form have Row Sources that are queries or tables related to the main table (Data entry is set to "Yes" since "No" prevents me from making any edits).

    Hope that clarifies---

  4. #4
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Hmm did you try actually running the query from the record source. The only way that I know of to get a blank screen like that is if the record source contains no data.

    Just try turning on addtions..you should then see all the fields.

  5. #5
    Join Date
    Mar 2006
    Posts
    17
    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

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 10-16-2008, 02:39 PM
  2. Replies: 0
    Last Post: 03-26-2007, 12:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums