check box in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access. On my form,
I created a formula to calculate Total Due...
=([DailyRate]*[NumberDays]+75)*1.08

Now, I want to add a check box to the form. If the user checks the box
(True), I want 100 added to the Total Due. If the box isn't checked, then
the Total Due doesn't change.

I tried an IF statement, but didn't have luck.

Thanks...
 
In the check box's AFTER UPDATE event put

If Me.YourCheckboxNameHere Then
Me.[Total Due] =(([DailyRate]*[NumberDays]+75)*1.08)+100
Else
Me.[Total Due] =([DailyRate]*[NumberDays]+75)*1.08
End If

--
Bob Larson
Access World Forums Super Moderator
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista
 

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

numerical summation to passed from sub to main form 2
total checked boxes on a form 2
Can a Check Box Prevent Other Fields from Being Used? 1
Check box Controls 4
Calculating a text box 9
How to display the TOTAL of a sub form on the parent Form? 9
Check box issues 2
Enter Parameter Value in Access Form 0

Back
Top