Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bford797
-
Dynamic Row Source for Combo box
Duh! I answered my own question... Build the sql statement dynamically, in a string, with vba, then set the combo box's RowSource property to the value of the string (sql statement). One can create any rowsource and change it at anytime based on user input in other fields.- bford797
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
Dynamic Row Source for Combo box
That's not the answer. The problem is not how to construct the sql statement. The problem is how does one pass a variable to the combo box's record source property from the Access form to sql server? The sql statement in the above answer will work in a .mdb file, but not in a .adb. How do you do...- bford797
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
