Selasa, 19 Juli 2016

Re: [MS_AccessPros] Combo box confusion

 

I figured it out. I did not have the column count in the properties set to the correct number and the widths were not set.
 
Jim Wagner


On Tuesday, July 19, 2016 4:06 PM, "luvmymelody@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
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: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

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