Display full address after clicking combo box 1

[Neowynds]

I have a Security Incident Report database I am working on.

The Posts table has the Name of each Security Post, Address, State, Postal Code, and Country. The Name field is the PrimaryKey

The rest of my info is stored in Table1

On my form I have my [Post:] field accessing the table named Posts.

On the [Address:] field of my post, in the data tab of properties I put in =[Post:].Column(1)

In the form. When I pull down and highlight a post it fills in the address field fine.

However I have 4 more fields that I tried to put
=[Post:].Column(2)
=[Post:].Column(3)
=[Post:].Column(4)
=[Post:].Column(5)
into thier data field and nothing happens why?

Neowynds

 

[RoyVidar]

Hi!

Have you included all of those fields to the combos row source? You'll need em'all.

How?

When using the combo wizard, select all the fields you need, and complete the wizard.

Afterwards (if you don't wan't to display all fields in the dropdownlist), replace the different width-settings for the fields with 0cm in the Format Column width property of the combo. I e:

0cm;2cm;0cm;0cm;0cm;0cm

in stead of:

0cm;2cm;2.54cm;2.54cm;2.54cm;2.54cm

HTH Roy-Vidar

 

[Neowynds]

Hmm... OK I did that and it works. But I decided to go a different route by putting the whole address in one field but formatted like a mailing address. So when the post is selected the address field will automatically populate the Mailing address of that post. But helpful response none the less as I will use that later in this database. Thank you

Neowynds