sub form behaviour

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beagles
    New Member
    • Sep 2006
    • 5

    sub form behaviour

    Hi
    I am new to access so I apologise in advance for asking 'rookie' questions.

    I have a main form that the user selects a project from a combo box, I then display the information for that project on a sub form. To select the infromation for the project I have a query in the recordSource of the subform that uses the cboproject.valu e in the selection criteria.This seems to work OK.

    My problem is that I cannot edit any of the fields on the subform. All the fields are text boxes with the enable attribute set to 'yes' and the locked attribute set to 'no'.

    Any ideas?
  • PEB
    Recognized Expert Top Contributor
    • Aug 2006
    • 1418

    #2
    Is your recordset on which is based you subform is editible?

    Can u enter some information and then appears the error that u can't add

    or simply u can't introduce nothing?

    :)

    Comment

    • beagles
      New Member
      • Sep 2006
      • 5

      #3
      Originally posted by PEB
      Is your recordset on which is based you subform is editible?

      Can u enter some information and then appears the error that u can't add

      or simply u can't introduce nothing?

      :)
      I can see all the fields in the sub form but cannot edit any of the data - I don't get any error messages - it is as if the fields are not enabled. I suspect the probelm is due to the fact that I am using a query to populate the subform.

      Comment

      • PEB
        Recognized Expert Top Contributor
        • Aug 2006
        • 1418

        #4
        So open your query and try to edit a field if u can't so u need to change your query!

        :)

        Comment

        Working...