Selasa, 19 Juli 2016

[MS_AccessPros] Combo box confusion


Hello all,

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?"

Thank You

Jim Wagner


Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.



Tidak ada komentar:

Posting Komentar