|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
|Comment||Hi Scott, Couldn't quite get yours to work, so I put aboslute references in for the field names, etc, and that worked! As in... Me.ListStkCode.RowSource = "SELECT TblProducts.StkCode,TblProducts.StkDescription FROM TblProducts WHERE (((TblProducts.Category)=[Forms]![FrmPRoducts]![CboCategory]));" Watch for line wrap in that too! All that was on one line. cheers Pete|
Answers by Expert:
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Brooklyn College BA