dropdownbox inserts value depending on the choice

[megatronixs]

Hi all,

I would like to add a dropbox (combobox) in my form that when you choose a country from it, depending on what you choose it will insert in another field a value. So far I have only 1 country that inserts the amount, but if the choice is "rest" then it will insert a 0.

The field for the choice is called: Location
the field for the charge amount is called: ChargeAmount

the combobox has the choices: UK, Other.

Any help in getting this going on, would be nice.

Greetings.

 

[ck4794]

on the macro builder, click "show all actions" and then the setvalue macro will be available. i would do this through an if statement. ie:
after update
if (your combo)="uk" then set value (whatever object)
else if...

if you need more help ask. word of warning access finds this macro "dangerous" and i'm sure that's for a reason. I've had pretty good luck with it so far.

 

[megatronixs]

Hi,
thanks. I will check this more, but I guess I need to make still some changes to the database.
I made created a report for the client charged so far and once the report finished, it needs to run a change query to fill in some fields so the client don't get charged again. The problem is that my database got corrupted after running that query.

Greetings.