Lookup on form to open report

[Nadine67]

Hello and thank you in advance for any attention this post may receive.



Windows XP
MS Access 2010

I have a listbox (lstSelect) in a form with Row Source SELECT [ID], [Status] FROM tblStatus ORDER BY [Status];. The list box is used as the 'Status' criteria for records (from tblImprovements) displayed in a report. The trouble is the report opens it only displays a single record. And that single record is the record that has the ID number the same as the position of the selected criteria. By that I mean if i select the third option in the list, then the third record is displayed.

tblImprovements has column [Status] and it is populated by selecting a value from the same tblStatus as the list box.

Why is it so that the Id's are mixing up?

Thank you

Nadine

[June7]

What do you mean by "Id's are mixing up"? Nothing in your description indicates to me that anything is mixed up. Listbox provides criteria for filtering report. Report shows records that match the ID. Sounds perfectly normal.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Nadine67]

Hello Jun

I worked out my issue. I was using the incorrect ID name in the formula.

Thank you for your reply June. And yes it did sound 'normal', and it wasnt returning an error to indicate an issue either.

Glad I worked it out because not only is it returning what I want, it was a good learning for myself.

Nadine