[MS_AccessPros] Using SQL in the Row Source

 

this is likely a simpleton question, but I need to ask since I am not certain.

If I have an unbound form with a parent and child list boxes,  a form style I find myself using a lot.  For my education I want to write SQL code for the row souces of the list boxes.  I have always used the row source of the list box properties and used the query builder to build the queries that serve as the row source.

I'd like to practice writing the SQL code using the strSQL = strSQL & "..." process to build the list boxes.  Where do I put the SQL code?  Do I build the SQL statements in the Form_Open event? and then just assign the SQL to the list box control?

me.lstOne.RowSource = strSQL1

me.lstTwo.RowSource = strSQL2

__._,_.___

---

Posted by: david.pratt@outlook.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___