Recent content by CalvinToo

Dk, All good suggestions I plan on using / taking. I'll try making those changes and see what I can figure out it likely is something simple but sometimes you can't see the forest for the trees ;) Thanks for the assistance :D Cheers Calvin

Here it is. I noticed after looking at the form I should also force the user to take ownership of the report so I'll have to enforce the MTEMP field as the other 5 as well once I get them sorted out. (click to enlarge) Thanks again

dk, I just entered all the other "controls" other then ProductID and it works so far in that it doesn't return any error codes but I've noticed that the only time it stops you from moving to the next record is if you have the Contrator (MTTOCONT) field filled in. It is ignoring the other...

I should post this combo box as well for the "ProductID" in the field. I'm not sure what to look for ?

It appears that ProductID is the trouble maker it is the one returning the error "2465" Here is a look at the properties. I'm not sure but I think it causing the error due to the tables? I think I'm getting closer to locking this one down :) Thanks again guys! Cheers Calvin

Dk, I think your a genius. Anyway I made the changes more or less and removed these "wrappers" as with them in I was still getting errors This is the remaining code and it appears to work - Now I just need to re-introduce the coding above step by step to force the front end user to fill in...

I know I owe you huge - I will definetly be buying a you a drink or two if I ever go through your neck of the woods in my travels :cool:

Here are the Properties of the "buttons" both cmds go back to the coding posted above. (Click to enlarge) Hopefully this is enough but let me know if you need anything else (my head is spinning from looking at this all day) Cheers Calvin

Here is the coding I'm working with. I'll post the properties next. Thanks guys! Cheers Calvin

dk, It is a number (phone number with input mask actually) but as such it is a text field so I could use the input mask. I've removed the link and actually removed everything just leaving the contact field as a blank text box so that the front end user can just type in any name for the company...

Ok I've worked my way through getting the forms to populate the drop down boxes and I have the coding in that shows the error messages if I hit either button when the form is empty. However the (contact field gives me the error! Here is the screen shot of the properties of the "drop box" that...

Thanks Craig. I appreciate any suggestions and help here. I'm learning as I go here he-he pretty overwhelming at times oh and maddening ;) Right now I'm working on getting the information from the other forms to populate the drop down selection boxes on this form before I can test for other...

Craig, I thought about the drop down / combo but I think by the end of projects they will likely have several thousand transfer reports and I want them to be able to see not just the number but also who it went to and what the product was by scrolling through reports that have been previously...

RuralGuy, I meant no disrespect to ghudson I'm sure the code is excellent and I take full responsibility for it not working... I'm 100% sure the error is on my part not his :) Cheers Calvin

Thanks Craig! I'll try out the new coding and see if that works. I found what I think the error was after changing "UnitsSold" to "UnitsTransferred" I thought I had it but it was actually my first line of coding that was causing the error Private Sub cmdMT_Click___Click() I had to remove...