How to launch new form from a filtered list selection

[karmadog]

Hi all,

I was able to create a DB that filters all the fire extinguisher labels of a three campus area based on cascading combo boxes that drill down to County/Campus/Building/Floor/Section.

I want to be able to click on an FE label from the filtered list and cause another form to open that will allow me to enter meta data about that particular fire extinguisher/label, i.e is it up-to-date, sitting on the floor or on the wall, is the label correct, etc.

I'd also like to mark each selection in the filtered list as complete after filling out the meta data form so I know which FE's are remaining to be audited.



How do I do that?

Thanks in advance,
Dangerous Newbie

[pbaldy]

You mean open a form filtered to that record?

BaldyWeb wherecondition

[karmadog]

Sort of.

My goal is to be able to audit the condition of many fire extinguishers (FE's) for many buildings.

I start by filtering the entire list of FE's based on the location I'm at, i.e. which campus/building/floor/floor section etc.

Once I have that filtered list, I need to collect field data, one at a time, for each of those FE's listed on my filtered list.

Hope that makes it more clear.

[pbaldy]

How does the link not accomplish what you want?

[karmadog]

My limited understanding is that your link indicates opening a record and viewing its data on a second form. It doesn't seem like the results from my filtered list are actual records, but just query results with no corresponding data to view.

[pbaldy]

I assume that the results of your filtered lists provides the key value (the fire extinguisher) that would enable you to open a form based on the fire extinguisher table to the selected extinguisher.

[karmadog]

I'm just not sure how to access the result(s) from the list.

Can I just double-click one of the filtered results from the first form and have a new form open that will allow me to add data to the record?

[pbaldy]

Presuming you have it set up, replacing ControlName in the code from the link:

Me.ControlName

with the name of your listbox should pass the fire extiguisher to filter the second form.

[karmadog]

Where do I put the code? I can't find a property sheet for the filtered list.

[pbaldy]

Based on your sample, it's a listbox named "lstLabelID". Clicking or double clicking on it should open the properties window for it. I'd either use the click or double click event for the code, depending on your preference.

[karmadog]

Thanks Paul! I'm getting an error, but it still works!

[pbaldy]

I would expect that code in the click or double click event of the listbox. It appears you have that in the load event of the form being opened, so that reference to the listbox is invalid. You say it works, but I wonder if the form is displaying all records.

[karmadog]

I removed the code from the load form event, and now it works without the error. All I have to do (hopefully) is add the metadata fields to the second form to populate the record for each fire extinguisher.