Recent content by Celtlink

Hey Poppa Smurf ! Fantastic ! took out the call update sub and it now works... thanks very much for your assistance.....appreciatted.... sorry for delay in response, see your out in oz...time diff to UK had to go to bed as was knacked... thanks again Brian

Discount and Price are two separate fields. I have "Quantity" "UnitPrice" "Discount" "Price" Discount is a percentage. I need to work out the Price.

Hi Please help with below: Fields are Quantity UnitPrice Discount Price I cannot get Price to update the total....? Private Sub ProductID_AfterUpdate() Me.UnitPrice = Me.ProductID.Column(2) End Sub (This bit actually works and places the product price in UnitPrice) Private Sub...

Hello David, Bob, Extreme thanks to you both for helping me understand this problem ! Fantastic news - IT WORKS !!! :D Great stuff cheers guys Bnan

Hi David, i have checked and even pasted in your code and all is correct places, but still have same error on click command in Form_Customer for CreateOrder Button Click() The Debugger highlights the following line in Yellow: DoCmd.OpenForm Form_Orders, , , , acFormAdd, , Me.Title & "$" &...

the error is: An Expression you enabled is wrong data type for one of the arguments

the DoCmdOpen am putting this in the Form_Customer form in the button for Click

sorry line stopping is : DoCmd.OpenForm Form_Orders, , , , acFormAdd, , Me.Title & "$" & Me.CName

Thank You David, I now get a debug error on the DoCmd line in the Form_Customer ? Private Sub CreateOrder_Click() DoCmd.OpenForm DocName, , , , acFormAdd, , Me.Title & "$" & Me.CName End Sub sorry for being so stupid.... thanks Brian

Hi, I need help especially reading forum answers for this type of question and still cannot do it. I have the first form open "Form_Customer" with a button on it called "Create Order". when I click on the button I want to open the "Form_Orders" form. (this I managed.) On opening the...