Search results

Now getting a #error Putting THIS : =IIf([Referral_Received_Day_1]>[Bill_DAY],[Application_Applied_Month_1]=([Referral_Received_Month_1]+1),[Application_Applied_Month_1]=[Referral_Received_Month_1]) in the control source yields a new error: #Error Any thoughts?

:((( Is my syntax right? Ok...not sure if im putting my argument in the right place....OR...what the CORRECT logic test is. I tried this: (and it had errors in compiling) --------------------------------------------------- Option Compare Database Private Sub...

Ahhh Ahh...i think I know how it will know... If the logic im using is: IF(logic_test,value_true,value_false) Then I set the value for the specific variable using the value_true/value_false parts. But the question then becomes does it place the actual number into the field on the form? (Im...

getting closer Ok...getting closer. I appreciate you telling me where to click...that helps. ;) My next question is...how does this new button know which field I want the generated number to be put into? Also if will it matter if those variables (A,B,C..etc in my explanation) are Fields/Field...

Heres my problem... I have a number field that I need to have a value based on the comparison of two other variables. Keep in mind each of these variables is a FIELD on the form. Eg. If A > B then C (this field)= D+1 Ive tried editing the Control Source (making an expression) and putting...

ok...how Ok im new to Access....So im setting up an event...based on a the keystroke of the other field? HMMMMm not sure how to do what you're explaining...could you get a little more specific?

Heres my problem... I have a number field that I need to have a value based on the comparison of two other variables. Keep in mind each of these variables is a FIELD on the form. Eg. If A > B then C (this field)= D+1 Ive tried editing the Control Source (making an expression) and putting in...