Recent content by Spot On

Sorry for the lack of communication! What I need the tab sequence to do is - After selecting a customer Name in my Main form, I then tab direct to my productID in the subform which is in a tab page (named sales details). Eg:Line ProductID = Hair Cut Qty = 1 UnitPrice = $99 Discount = $15%...

How do I code a tab control sequence? After selecting a customer Name in my Main form, it automatically tabs to my productID in a subform which is in a tab page (named sales details). After the line/s items have been completed it auto tabs to the next field Booking date on the next tab page...

Ian, Your a legend, It worked perfectly. I had all the criteria right except for the .Value. Am I right in understanding that . Value = stABCD applies to a text field as well? I really apprieciate your time and guidence I'm sure I have other questions as I get into my program as time goes on...

Hi Ian, Still can't make the program work in my form. Keep getting error Access cant find Sbf_SalesDetails. Yet if I open the subform only, the program works:D I tried adding the Sales form name as well, but still errors with cant find that form either. How my form works is the main form is...

Thanks Ian, Your sample is exactly how I want it to work. So I applied it to mine but when I click on the pop up to update, access say's it cant find the form Sbf_SalesDetail in the basic code I changed the code to reflect the form but still does not work. Is the problem the subform? Peter

Ian, The code was not working for me. It errors from the start, debugging from the text in green. So I deleted txt in both areas, still did't work so I changed Me. to just Me.Discount. When I entered a value in the discount field, a pop up says no record found. What I'm trying to achieve is when...

Thanks for that! It worked fine. But now I'm have trouble with the macro info, i think I dont have the right set up because when I look at my Query for the discount reason it adds extra line ID's Example of query SaleID LineID Discount Discount Reason Unit Price Extended Price 1 1...

In my products subform I need to have a pop up form (ie reason for discount) when a user changes the discount field value. How do I go about this please?