Search results

Its good to hear that advice and understand the way in which people would expect you to 'do things'. Thanks missinglinq you have been a great help and it is very much appreciated.

OOPS yes you are quite right and is exactly what I meant. Silly me! Is there any advantage to using this method and not needing to use code 'behind the scenes' so to speak. I am still new to Access and am trying to work out if it is best (or convention) to avoid using code whenever possible.

Hmm yes. I was thinking along the lines of whether something like this would work? Total =([cost to be multiplied]*[Multiplier])/100 Which is why I was thinking of using 10 and 20 rather than .1 or .2 and thus not having to use the (minimal) piece of code.

I was thinking about using an Option Group as you describe as the two options of 'internal' and 'external' will represent a percentage mark up. so internal = 10% hence the need for the 1.1 multiplier and External = 20% hence the *1.2 multiplier. just wondering whether it would be better to...

Many thanks. Just one further question, Is there a simpler way to do this, to get the combobox choice (text) to represent a number value instead of coding it as above?

Thanks for the help it is much appreciated. I have done it in the same manner as missinglinq but have used If Then instead of Select Case as follows Private Sub Source_Change() Dim Multiplier As Single If Source = "Internal" Then Multiplier = 1.1 ElseIf Source = "External" Then Multiplier =...

Hi, I have been trying to work out the best way to do this but seem to have got myself confused as i am sure this should be fairly simple. I have a Combo with two choices 'internal' and 'external'. I would like these 2 choices to be used as a multiplier in a price calculation eg. internal =...