User Profile

Chucara

Last Activity: Dec 3 '06, 04:52 PM

Joined: Nov 30 '06

Location:

Chucara replied to Access: Update Listbox from query

in Visual Basic

Nov 30 '06, 03:49 PM

Code:

Private Sub region_Click()
   Dim db As DAO.Database
   Dim qdf As DAO.QueryDef
   Dim varItem As Variant
   Dim strCriteria As String
   Dim strSQL As String
   
   Set db = CurrentDb()
   Set qdf = db.QueryDefs("qryMultiSelect")
   
   If Me!region.ItemsSelected.Count > 0 Then
      For Each varItem In Me!region.ItemsSelected
         strCriteria

...

See more | Go to post

Leave a comment:

Chucara started a topic Access: Update Listbox from query

in Visual Basic

Nov 30 '06, 02:38 PM
Access: Update Listbox from query

Hi,

I'm trying to build a simple search in Access. I'll just give a simplified example, as I think I can solve the problem, if you can help me with this subproblem..

I have 2 listboxes - "Region" and "Country". "Region" supports extended multiple select.

I want the Country listbox to populate with all countries in all of the selected regions.

So far, I can do...

See more | Go to post

No activity results to display

Profile Sidebar

Leave a comment:

Access: Update Listbox from query