Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Thanked 0 Times in 0 Posts

    Edit a Crosstab Subform (Access 97)

    I have come to the realisation that a subform based on a crosstab query cannot be edited. From previous searches I believe that this issue can be resolved by using the On Got Focus event to show a text box that can be edited. However due to my "Newbie" status I am unsure as to how attach the appropriate Control Source to this text box. Would greatly appreciate any help or directions on this
    Thanks AH

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Edit a Crosstab Subform (Access 97)

    A crosstab query always displays grouped data instead of individual data. Therefore, a crosstab query is not editeable, and neither is a form based on a crosstab query. You can't display an editeable text box on the same form. You will have to create and display another form based on an editeable query if you want the user to be able to modify data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts