Combo or Text box?

  • Thread starter Thread starter tinab
  • Start date Start date
T

tinab

I have a report that has fields for both client billing address and
job address. On the form I have billing city and job city and both
have a combo box with data from a cities table. I have used combo
boxes on the reports and it works but would like to use text boxes (to
grow & shrink). How do I set up a query to do this? I looked at
OrderEntry sample db at the invoice report and saw that they have the
products table in there and take the product name from that table but
they only have one productID. Thank you.
 
If you have two similar combo boxes in your report, you will need to add the
row source from the combo boxes to your report's record source twice. Join
one copy to the billing city and one copy to the job address city.
 
Combo Boxes are for user interaction; since that is not possible on a
Report, you might as well use a Text Box. Setting the Can Grow and Can
Shrink is just a matter of setting properties, not a matter of the Query.

It really doesn't matter what you have on the Form, but it really does
matter how you have defined that Field in the Table. If it is a lookup
field, then you will need (though it is not obvious) to join each of the two
City fields to a copy of the City Table. If it isn't a lookup field, but
only a Foreign key, then it would be obvious that the join was needed.

If I haven't made myself clear, please follow up here with a description of
your data and table design.

Larry Linson
Microsoft Access MVP
 
Back
Top