Recent content by Fi

sorry that was a bit fuzzy, on the form I would like to be able to choose the fund and then the date of investment from the 2 combo boxes (already set up and working)once these choices have been made I would like the interest rate applicable for this fund on this date to be entered in the...

Hi I am trying to use the choices made in two combo boxes, one to choose an investment fund and one for the investment date the choices made would determine which interest rate should be used and I would like this value to appear in the text box, Can anyone help ???? many thanks

Thanks for your reply Pat, I am trying to get this to work but can't seem to get it, I have created a query based on the table that the subform is based on, in properties of the query should I use 'Interest Rate' or 'ClientID' for Order By ? should I base the subform on the query also, or should...

Hi Jon In the control source of the cell you are using to calculate 'TotalOrderCost 'in try this =Sum([Forms]![OrderDetails]![Price])+Sum([FreightCharge])+Sum([PriceAdjustment]) I am doing something similar and found that if there was no value in one of the cells in the calculation then it...

thanks for the replies Pat and Jack, I have tried your suggestion Jack in the control source for the cell but it gives me an error message, have I put it in the correct place, should it be an event ? I'm a bit lost about the X, sorry still a bit of a novice. For the query Pat, should the...

try this Jon =Sum([Price])+Sum([Forms]![Orders3]![FreightCharge]) Fi

Hi..I'm trying to show the last figure entered in a cell, on a continuous subform. Using DLast I can get the expected figure to appear but it is the last one entered over all records whereas I would like to see the last one for that particular record, the DB has a main form Clients and a subform...