Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: Syntax for Report

    Hello
    I am hoping someone could answer this question. I have a form that has a combobox, cboStoreName, that isn't linked to any tables, tblStore. It just has an autonumber and a corresponding data. I am going to print the contents of this form so I designed a report. However, when the report prints, the txtStore prints a number rather than the store name. I am getting a 5 rather than "Jill's Flower Power"

    In the control source of txtStoreName, I entered the following
    =tblStore!StoreName but a parameter pops up when I open the report.
    Many question is, How can I get the name of the store to display (print)?

    Thank you,
    Jenny
    Last edited by Jenny M; 11-11-04 at 18:57.

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    You need to bind your combo box to the 2nd column. It sounded like you combo box had two columns. One for the number and one for the store. The bound column is what will get printed on your report.

Posting Permissions

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