Updating a value in a form - using a macro

jazztie

jazztie

Joined
Jun 8, 2005
Messages
5
Reaction score
0
I'm completely lost... I don't understand the logic of Access.

What I want to do is update a value in a form when another value is changed.

What I have now is:
Value onChange - run macro "25Procent"

This macro does:
SetValue
Item: [Forms]![Tarife]![Value25]
Expression: [Forms]![Tarife]![Value]*1,25

But I always get an error. When I run it in the macro window it reads 'Out of string space' (what does this mean???) ... when I run it in the form window -- it errors as well.

What am I doing wrong? Both values have the same format (euro) --- both have Control Source's (resp. Value and Value25)

any help is appreciated!
Jazz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Macro - this should be simple, right? 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
using If,then, else statement in a macro 1
Pasting cell contents into a macro 1
Append query using an iif function not working within a macro 6
Access Macro Repeat Expression using value of a field in table 0
Parameter Value error in a Subform 0
Help with SetValue on a different field in a form 1

Top