[address1].column(1): field info disappears when cycling records

[Guest]

I posted a message recently but no response.

I have two combo boxes which are cascading. The first chooses a customer
name and the second lists the valid first lines of address for that customer.

In this 2nd combo I also have the rest of the address of the contact info
and I am using further unbound text boxes to fill in the fields using the
second combo as the reference using [address1].column(1) etc

Although the name and first line remain, when I cycle through the records
the rest of the fields for each record disappears. How can I make sure they
remain visible when I move from one record to the next?

cheers

 

[BruceM]

The Address1.Column(1) information needs to be either in the control source
of an unbound text box or assigned to an unbound text box in the form's
Current event. I'm guessing you are filling in the information using a
combo box After Update event, but that event does not apply to other
records.

 

[Marshall Barton]

I posted a message recently but no response.

I have two combo boxes which are cascading. The first chooses a customer
name and the second lists the valid first lines of address for that customer.

In this 2nd combo I also have the rest of the address of the contact info
and I am using further unbound text boxes to fill in the fields using the
second combo as the reference using [address1].column(1) etc

Although the name and first line remain, when I cycle through the records
the rest of the fields for each record disappears. How can I make sure they
remain visible when I move from one record to the next?

The form's Current event should have the same code that you
have in name combo box's AfterUpdate event (Requery or
setting the RowSource).