I forgot to mention. The requery will only work if the two cbo are tied together. If they are not tied together, you will have to search the records based upon the value of the cbo you have choose. You would write the vba code for each one in the onchange event.
Brodi
To keep your cbo updated. Use the event property of the cbo. User the onchange of the cbo. Write the code for the onchange to requery the other cbo.
Here is the code for the onchange of the phoneNumber cbo
me.cboName.requery
Here is the code for the onchange of the Name cbo...
How do I make a report two column. Similiar to a phone listing. I just have a report of names and phone numbers. I want to save space and have two columns of names.
It is actually a very easy process to pull data based on a zipcode, only if each business has a unique zipcode. You web page must be tied to a back end database. Either ASP for IIS servers or Cold Fusion. The only way you can pull the address is if each business has a unique zipcode. If two...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.