Recent content by sned

Thanks, I now realise I was being stupid, and I have now sorted the problem, Si

Thanks, but I need to calculate another field from it so how do I do that? Thanks Si

I've got a subform with a combo box in it. When the user selects from the combo box I'd like it to look in a table and add a value into a textbox on the subform. How do I do it? Thanks Si

Does anybody know how to create a subform in a XHTML form? I want it to behave the same way as in access or as similar as possible. Thanks Si

Question 1 & 3 Something like this? Sub Intr_Code AfterUpdate() Dim ProdGrp$ ProdGrp$ = Prod_Grp.Text Select Case ProdGrp$ Case "EA" Intr_Code.SetFocus Intr_Code.ValidationRule = "Not ''" Intr_Code.ValidationText = "Must have a value" Intr_Code.Locked =...

This code will count the number of words in a memo field when the control has lost the focus. It could also be used on OnUpdate. Private Sub mmoSecond_LostFocus() Dim First$ 'Variable to hold memo string Dim arr As Variant 'Variable to hold string when split (array) Dim n% 'Variable...

How do I find how many items in an array?

I have a subform which contains the price and quantity of items required. In the main from I have a field called total cost. I'd like the total cost field to calculate for all of the items in the subform. (It's probably blindingly simple but there we go.)