Search results

Just wanted to post a quick message to say Thanks. I was having the exact same issue, I changed the setting as per above and it solved the problem.

Ok thank you, its fixed now. The record source for the form that I was trying to open got screwed. When I pointed it to the correct table, it started pulling info. for all items in the list. I think this needs a bit more explanation as to what I was trying to do. I had created an Audit...

Thanks for the response. I have 14 columns on the list box and yes, the ContractInitiativeID is the first one on the list. I added the column(0) as you suggested but i am still having issues. The first 3 items (search results) pull data from the table on a form when double clicked but when i...

Hi everyone, I need some serious help. I just cant figure out what is going on? First, I am not an expert but I am building and learning database at the same time. I have a search form that searches the inventory from a table and the search results are shows at the list box below. When the...