List box drop Issue

[JonM]

I am going to state what I have, then the issue. Due to privacy reason I can not share specific information.



I have four tables and a switchboard. tblLocation - Location Number(PK), Location Name. tblToolCode - AutoToolCode(PK), Tool Code. tblTools - Tool#(PK), Tool Code, Tool Description, Manufacturer. tblVendor - Vendor#(PK), VendorName, VendorAddrss.

I have several forms, but I am only going to list two. frmToolLocation - that has a list box from tblLocation and a button that opens a report based on query.
frmToolInfo - which list all tool information including list box to change location.

Here is my issue. When I use the form frmToolLocation, then I switch to frmToolInfo. The first record location is changing based on frmToolLocation last selected. How do I keep the frmToolInfo location from changing?

[June7]

Sounds like the listbox is bound. Can't use bound controls as search criteria input. Selecting an item from the list changes the value stored in table. Use an UNBOUND control to input search value.