ComoBox Does Not Display Bound Record

[boblarson]

Yep, so it should happen, but I've seen it fail before. A perfectly normal form but won't requery unless forced to.

Must have been some other issue then because it is impossible to have a recordsource change and the form not requery to get the records specified by that record source. Just isn't possible. So there was some other issue that you obscured by requerying the already requeried source. As Bill Murray said in the movie "Stripes" - "That's the fact, Jack"

 

[vbaInet]

Must have been some other issue then because it is impossible to have a recordsource change and the form not requery to get the records specified by that record source. Just isn't possible. So there was some other issue that you obscured by requerying the already requeried source. As Bill Murray said in the movie "Stripes" - "That's the fact, Jack"

This was a long time ago anyway and the subform was unbound. There was nothing obscuring it as I had stripped the form of all code and it wasn't corrupt either. I only requery if I find that the default requery isn't working as expected. Just weird I guess.

 

[gray]

Hi

Thanks for your replies. I tried various requeries of subform and subform controls but nothing invoked the display of the records other than switching between Form / Datasheet views? It's all very odd... I looked at all the properties of my comboboxes but I don't see anything obvious that would prevent the records from displaying?

"In the attached db there is no test data that we could test it on in order to see what's happening" - That's strange... there should be :-

71 records in the Addresses table
67 records in the Contacts table
7 records in the Organisations table
141 records in the Addresses_To_Contacts table
and
101 records in the Addresses_Trganisations table

Using the 'Select' buttons in the 'Assoc Contacts' and 'Assoc Orgs' tabs will add items to the subforms..

Thanks