Recent content by Bjorn_DA

Problem solved. I put an Close subform-macro on the current event of the main form. So by clicking customer name the subform is closed and then re-opened.

Hi again This form worked perfect and was very appreciated by our sellers. But now I have a new, similar project. The principle is the same; by clicking on the customer name in the main form, a new form opens that contains a tab control with a page for each product (lets say product A, B and...

Your my hero! :) It took me a while before I found the tag control, but now I get it. Thanks a lot!!

Thanks a lot! I dont get it to work now, maybe dont understand clompletly, but its late and I think I need to sleep my cold away. Will try tomorrow again. :)

Yes, here it is. I really appreciate your help :)

Strange, now I am getting error when open main form... :banghead: I attach a sample-db (MSA 2010), without the code. Search "sell01" and open up a Customer card.

Its just not hiding, the code is "accepted".

Yes its a subform on the first tab but its always a record in it, so that should not be the problem. I will try again with your code, maybe I made something wrong yesterday. If I dont get it to work I'll create a sample-db to post here.

Apologies that I havent responded earlier, have a cold and fever ... :( Thank you both for your replies! I think Artair is closest to what I'm looking for, because I did not create queries to the tab-subforms. But I can't make it work. Could it be because the subforms are datasheets?

Hi I have a main form where I choose customer that opens a new form with customer info and a tab control, with different products for each tab for that specific customer. It's a total of 17 tabs. The tabs contains subforms created on the tables (not queries). So far so good, everything works...

Yep. When I have 10 posts I can link it :)

Anyone have a clue how to do? I saw that the option buttons in the Dynamically search multiple fields actually are frames with On click-code: I want the exact thing*, but with combo boxes (and maybe a text field). I have tried using this code on a combo but it didnt work. * I have first a...

I solved the main issue thx to the thread Dynamically search multiple fields (I can't link to it): Instead of showing all info in one form, it know works like this: 1. Enter the SellerID in text box, result shown in list box. 2. Select a customer from the list box, hit the button and a new...

Hi again I have now a basic form that works, but I would like a better filter functionality. What I have is a form created on a qry with a combo box wich selects customer. Below it I have put in a Tab Control, with tabs for each product (tables as subforms). When I select customer the...

Thanks for the link, I will look that up.