Problem finding sollution.

[Zerdax]

Hi i need a help using a formula in a textbox

I want this.
That i can enter an value in the textbox. if not enterd any value it should then import the value from another textbox.
first info:
The textbox containing formula:
=[Selling price wholesale]
Import value from if [selling price wholesale] is empty:
=[text97]

I enterd this formula in [selling price wholesale]
=IIf(IsNull([Value]);[Forms]![Register Form]![Text97];[Value])

But what this one does is that it imports the starting value from [text97]. That would be wrong in my case. Because the [text97] will be 0 in starting.
[Text97] is a result of a calculation that will calculated when enterd data in other textboxes.

1.To have it clear for me. Is it possible to both enter an value in a textbox and import if not enterd an value ?

If yes how ?

2. Basicly it should be like this that if value change in [text97] [selling price wholesale] should also change except from that i manualy enter an value in [selling price wholesale].

Have tryed to ask many but no sollution.
had a thread for it before but cant find it.
plz help.,.

 

[ProgramError]

=IIf(IsNull([Value]) , [Forms]![Register Form]![Text97] , [Value])

Are you sure the combobox will contact a null? or will it be a "" try both.

I usually use something like =IIF([value],[Value],[Forms]![Register Form]![Text97])

Program Error
Programmers do it one finger at a time!

 

[Zerdax]

not sure of that that i will try both. iam trying to figure it out. Can try ur formula and c if any luck.

 

[Zerdax]

No luck with ur formula to. In my access you have to have ; not comma.

Any other suggestion.

 

[Zerdax]

Any help....
need this code. plz help me