New guy here, need help with controls on a form...

[SimonSezz]

I have been learning Access 2007 for about two weeks now and I'm trying to copy a program for my business. We had an old Access 97 database and we lost it when there was a hard drive failure. All we have are recollections from memory and some screenshot prints of what the program looked like. I didn't do the programming on the old database, it was someone else a long time ago.

Now to the issue, I have this form that needs to have a listbox and a combo box. The combo box is used as a "quick search" for the list box. If a "Shop Name" is entered in the combo box, then it should automatically select it in the listbox. The old program actually used a text box instead of a combo box.

The listbox just lists the Shop numbers, names, addresses, etc from the table "tblShops". If a shop is selected in the listbox then I should be able to double-click it to enter a new form that shows shop details that I can edit or I can have the listbox shop selected and click the "Shop Details" button on the button to do the same thing.

I have attached an example of what I have so far for a better explanation. I changed the addresses and names for obvious reasons.

Thanks in advance for the help!

 

[missinglinq]

I've read a lot of strabge things over the years, butI've never heard of anyone using a combobox to find a record in a listbox! That's like having a book to find out what page the Smiths appear on in the phone book, then moving to that page in the phone book! Why not simply use the combobox to do all these things, omitting the listbox?

 

[SimonSezz]

I was actually thinking about that while working on this and you are right. But I guess the point of the listbox is to let the user see all of the entries (in this case the shops) displayed in order by their shop number system.