Unbound cbo Requery doesn't work

W

WoodyAccess

I have an unbound cbo (named cboContactID) which is controled by
cboSupplierID.column(2). An expression in a query - (Full Name:
[ContactFirstName] &" "& [ContactSurname]).

So when I select from cboSupplierID the details that are to appear in
cboContactID are a list of contacts relavent to the Supplier. I have set a
query then from this cboContactID so that when a selection is made the
results populate other fields (ContactTel and ContactFax) eg. Me.ContactTel =
Me.cboContactID.column(2).

This all works but when I scroll throught the records the ContactTel and
ContactFax numbers remain correct but the cboContactID goes blank.

I have Me.cboContactID.Requery in On Current Event of the form and in the
AfterUpdate of the cboSupplierID but it still remain blank
 
K

Keith Wilby

WoodyAccess said:
I have an unbound cbo (named cboContactID) which is controled by
cboSupplierID.column(2). An expression in a query - (Full Name:
[ContactFirstName] &" "& [ContactSurname]).

So when I select from cboSupplierID the details that are to appear in
cboContactID are a list of contacts relavent to the Supplier. I have set a
query then from this cboContactID so that when a selection is made the
results populate other fields (ContactTel and ContactFax) eg.
Me.ContactTel =
Me.cboContactID.column(2).

This all works but when I scroll throught the records the ContactTel and
ContactFax numbers remain correct but the cboContactID goes blank.

I have Me.cboContactID.Requery in On Current Event of the form and in the
AfterUpdate of the cboSupplierID but it still remain blank
Click to expand...

It's because cboContactID is unbound! Bind you combo box to the appropriate
field. No control souce, no data.

Regards,
Keith.
www.keithwilby.com
 
Top