I have a combo box that chooses a campus. Then the next combo box is populated with a select statement that works perfect to filter the next combo box to all building numbers on that campus.
The user chooses the building number and the next text box is populated with the Building name.
All is working great except I cannot get the last text box to populate the address of the building. I have code in the buildingNbr after update that works great except that the last text box address is blank. I play with the column counts on the code and I can get data if I duplicate the column counts. for example, if I put the same column count as building name or the column count as the building number, I get the same results in the text boxes. So I know it is working.
My question is "If there is any building WITHOUT an address will I get the blank results for any building I choose because there is no address?"
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|