|
|
check box in a form
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...
|
|
0
|
|
|
|
Reply
|
 Utf
|
10/18/2007 5:20:01 AM |
|
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
"rkolinsky" wrote:
> 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...
|
|
|
0
|
|
|
|
Reply
|
Utf
|
10/18/2007 5:48:00 AM
|
|
|
1 Replies
216 Views
(page loaded in 0.347 seconds)
Similiar Articles: How to make check box for select specific field form table ...Greeting, I would like to create a form that able the user to select fields using check box and allows it to print the specified fields. For example,... Linking Check Box in User Form to Workbook - microsoft.public ...I have a user Form with several Check Boxes in it. I would like for the Check Boxes in the User Form to Check or Uncheck boxes in a different Workbo... How can I insert a check box field? - microsoft.public.word ...I have not created a form in a long time. It used to be: Insert Form Field/Check box, and THERE it was! ....Now, with Word 2007, I cant figure it ... select all for check box.. - microsoft.public.access.forms ...HI.. I have a check box field in a continuous form... name is mCheck I want to have a command button Select All such that when clicked, all check boxe... Form filter by check box - microsoft.public.access.forms ...I have a table and a corresponding form with personal data and several yes/no checkboxes for years (checkbox for 2006, box for 2007, 2008) indicating... Check box change colour once checked - microsoft.public.access ...Hi can anyone please help me? I've created a check box in my form which shows what information is valid and what's not, if it's checked then it's no... How can I Enable a Check Box based on another fields value ...Hi There, I have a form with a disabled check box. I need to enable it when a certain value ("approved") is selected from a combo box. When I am i... Filter by Checkbox - microsoft.public.access.formsHi, I have a table that has date | payment | docket number | delete as the headings. The delete column is a check box column. On a mainform (1) i ... Check box on continuous form - microsoft.public.access.formscoding ...I have a continuous form listing available parts. I need to be able to select a part from the list using a check box (or something that will give a ... Update a date/time control when check box control is updated ...I have two columns in tbl.Jobs. One field is a bit data type that I named Jobs.OnHold and the control on the form is a check box. I also have a date... Forms : Check Box - HTML TutorialHTML forms - HTML tutorial ... C heck boxes are used when you want to let the visitor select one or more options from a set of alternatives. Add a check box to a form - Frontpage - Office.comWhen you create a form and add check boxes, you'll want to know ahead of time what you want to label them and whether it's imperative that site visitors check a ... Insert a check box - InfoPath - Office.comYou can insert a check box on your Microsoft Office InfoPath form template so that users can quickly enter true or false values. In this article When to use a check ... Insert A Check Box In Microsoft Word 2010Insert A Check Box In Microsoft Word 2010. Often, it’s useful to include check boxes in Word 2010 so that readers can check off items. There are two kinds of check ... How to Create a Check Box in a Word Document | eHow.comMicrosoft Word allows you to make professional-looking documents, and it includes features so that you can make interactive forms for use on a computer system or ... 7/22/2012 3:56:33 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 