Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    17

    Unanswered: Dynamic forms from Crosstab queries

    Can anyone help?
    My application uses a crosstab query to proved data about bookings. I want to present this dat in a subform, in Datasheet view. The trouble is that the field names change dependant upon the data in the cosstab, and therfore they do not relate to the textboxes in the subform! I have tried using Alias names and this works, but the Alias field name is shown at the head of the column, I want the actual field name from the crosstab to be shown, otherwise users will be confused by the alias column names.
    Is there anyway around this?? help!!

  2. #2
    Join Date
    Sep 2004
    Posts
    10
    couldn't you make the alias similar to the field name? maybe adding a character at the end or beginning that would be virtually ignored by those looking at it...just a quick thought...I am sure there is a more traditional way. I will let you know if I find it.

  3. #3
    Join Date
    Sep 2004
    Posts
    17
    The problem is Misty that the actual Field name the crosstab produces is the result of the users input into the underlaying table and that can be anything the user wants. It seems crazy to me that you cannot change the column haeders by code or expression

Posting Permissions

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