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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamically referencing fields in a recordset
Hi Everyone I am attemting to access the fields in a recordset using a field name derived dynamically, i.e. along the lines of : dim somevar as string . . . rs.fields(somevar) or rs!somevar This obviously doesn't work, as the methods seem to expect literal values rather than dynamic...- WatDisDo
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
Combo Box in Query Criteria
Hi SKO, Yes, you understand my problem, but I've managed to fix it. The approach you suggested was pretty much what I had done, but with the source cbo based on a select query, embedded in the control. The target cbo was also based on a select query embedded in the target cbo control. I took...- WatDisDo
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Combo Box in Query Criteria
Hi y'all I am running a select/where query in a combo box that uses the contents of another combo box in the criteria to provide the input for the where clause. (e.g. [Forms]![ADP Entry]![cboBuyerName]). I also want to requery (via macro) on either the lostfocus event of the source combo, or...- WatDisDo
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
