Combo Boxes

[tinab]

I have a Client Information form containing Billing Address, Billing
City and Billing Province with a combo box for the city. The data
source is a cities table with CityID and City Name. I have the
properties set with: bound to the City ID field with 0;1 so just the
city name shows. From this form I want to go to another form called
Estimate Information using a command button and linked to the customer
id. On this form I have text fields for JobAddress, Job City and Job
Province. I want the data to default with the CLient Information
billings address. The problem is that the city shows a number instead
of text. Does this field need to be a combo box instead of a text
field?
Thank you.

 

[Arvin Meyer]

No, you merely need to refer to the proper column in the defaultvalue
property for the City field:

= [Forms]![frmClient Information]![cboBillingCity].Column(1)

Column(1) is the second column in a zero based array of columns.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

The problem is that the city shows a number instead
of text. Does this field need to be a combo box instead of a text
field?

The number is what is actually stored in your table. (This fact may be
concealed from your view if you've been suckered by Microsoft's
misleading Lookup Wizard misfeature).

So yes; if you want to see the city name, you need to either use a
Combo Box, or base the second form on a Query which joins its table to
the City table to pull up the city name.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps