How to click in a list box and send that data to a form that is tied to a query

[Rockb]

I have a form that contains a list box. What I want to do is when the user clicks on the list box the value of the item clicked on is sent to another form that is tied to a query that has criteria [enter number here] so that the value is automatically passed to that popup box.

Hope that is clear enough.



I have a database that started off 15 years ago as a stand alone database at a single site, then migrated to a replicated database across two sites, then went to a .mdb file on a web server that we interacted with via .asp pages. It is now time to put it on a Sharepoint server so I have to do back to using Access for everything and it has been a LONG time since I have worked with Access.

[June7]

The parameter has to reference the listbox control. Instead of [enter number here] in must be like [Forms!formname!listboxname].

Otherwise, review http://allenbrowne.com/ser-62.html

[Rockb]

The parameter has to reference the listbox control. Instead of [enter number here] in must be like [Forms!formname!listboxname].

Otherwise, review http://allenbrowne.com/ser-62.html

I get an error Invalid Bracketing of Name

[Rockb]

I went back and changed it to [forms]![formname]!
[listboxname] and do not get an error but instead of displaying the form to select the item as I expected id just shows the text box to enter the desired item like it did before.

[Minty]

Post up the SQL of your query , the form name and the listbox control name you want to use.

[June7]

Use your actual form and listbox names.

[Rockb]

I went back and created a new DB with just a single table to hopefully simplify things to get the functionality that I want so I can then duplicate that on the full DB.

I then created a Form with a combo box that is populated by one of the fields in that table. I have the On click event for that combo box pointed to a macro that opens a query with the following:

SELECT Location.Location, Location.[E-Mail1], Location.[E-Mail2], Location.[E-Mail3], Location.TEL1, Location.TEL2, Location.TEL3, Location.TEL4, Location.TEL5, Location.TEL6, Location.TEL7, Location.TEL8
FROM Location
WHERE (((Location.Location)=[forms]![ContaceViewSelectLocation]![Combo0]));


My desired end result is a report that is based on that query but thought it may be easier to start one step at a time and displaying the query results seemed to be the next step towards the desired result.

[June7]

Did the query work? Is 'Contace' correct spelling?

I NEVER use dynamic parameterized query. I prefer to set report filter when opening the report. Have you reviewed the Allen Browne link referenced earlier?

VBA would look like:

DoCmd.OpenReport "report name", , , "Location='" & Me.Combo0 & "'"

Macro has equivalent functionality.