Recent content by abowlofsoda

I am highlighting businnessproducts table, going to create, and selecting Multiple Items. From there I am dragging and dropping the newly created (sub)form into a Contact Details form I have. This form is just a nicer layout of each record, to make it easier for the end user. To jump back a...

I figured the macro out finally after and day and a half of long hours of tinkering! On my subform for ProductID.. I'm using the combo box on the ProductID column. When I select the Product from the combo and hit enter to get to the next row- I change the combo there to add another Product...

Your post have got me far. I'm well on my way with subforms and combo boxes. I do have a problem tho. After renaming the ID field in the Contacts table to BusinessID- I now have a broken macro that is used on a form I have to open another form of the Contact Details. You can see exactly...

Thanks again. I'll work on that!

Thanks for the reply! Is the 'BusinessProducts' table something I am going to have to manually enter, after every time someone adds a new entry to the 'Business' table or is there some way to have that information update automatically into that table?

I am a database and Access newbie. I am using Access 2007 to build a database of Contacts. These contacts are businesses that carry 10 products we are looking for. Some businesses carry 1 of them and some carry all 10 (and many of them somewhere in between). I want to create queries that...