Checkbox or Option button

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

Guest

Which do I need? I have a form where a user can select one or to
contractors. If they select option/box 1 they charge 85 dollars an hour. If
they select option/box 2 they charge 105 dollars an hour.

Now, after they user makes their contractor selction, I have an unbound
field that will multiply which contractor they select with another field that
has how many hours they will work.

So, maybe to put it more clear: Field1 has how many hours are need to
work a job.
Field 2 / Field 3 are option or check boxs that determine which contractor

Field 4 automatically calucalates Field1 X what option was selected in Field
2/3.

Thanks
 
Please help. This is what I have it does not work:

If Me.FieldC = False and Me.FieldC = False Then
Me.FieldE=Me.FieldA.Value
ElseIf Me.Fieldc = True Then
Me.FieldE=Me.FieldA.Value*165.5
ElseIf Me.FieldD = TrueThen
Me.FieldE=Me.FieldA.Value*138
End if
 

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

Back
Top