[MS_AccessPros] Setting rowsource to a query in code

 

When a button is clicked on another form I am opening the Listings form and setting the Rowsource of cbo.search (an unbound box). The code I am using is:

'Make string for Rowsource for cboSearch box
strSql2 = "SELECT DISTINCT qListingContacts_SoldSellers.* " & _
"FROM qListingContacts_SoldSellers;"
'Set RowSource for cboSearch box
Forms!Listings.cboSearch.RowSource = strSql2

Is there a better way to do this? I am just using qListingContacts_SoldSellers as the base, but the only way I knew to put it into a proper string was the above.

Thanks!
Connie

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1
• New Files 3

Visit Your Group

MARKETPLACE

There's one number you should know, your Credit Score. freecreditscore.com.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___