Results 1 to 2 of 2

Thread: [RESOLVED] Object Required Error

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Apr 2005
    Location
    Debug.Print
    Posts
    3,885

    Resolved [RESOLVED] Object Required Error

    I am getting an error of:
    Object Required
    VB Code:
    1. Private Sub txtTaxRate_Change(Index As Integer)
    2.     Select Case Index
    3.         Case 0
    4.             Format(lblTotalsAndTaxes(5).Caption, "0.00") = txtTaxRate(0).Text
    5.         Case 1
    6.             Format(lblTotalsAndTaxes(6).Caption, "0.00") = txtTaxRate(1).Text
    7.     End Select
    8. End Sub
    If I do not format the labels (where the output is sent), it works but doesnt have the right format, but as soon as I format, I get the error. If I put the textboxes first, I am unable to update the text boxes and then the output doesnt happen. What should I do?

  2. #2

    Thread Starter
    PowerPoster
    Join Date
    Apr 2005
    Location
    Debug.Print
    Posts
    3,885

    Re: Object Required Error

    ok, i fixed the problem. i was doing it the wrong way. this works:
    VB Code:
    1. Private Sub txtTaxRate_Change(Index As Integer)
    2.     Select Case Index
    3.         Case 0
    4.             lblTotalsAndTaxes(5).Caption = Format(txtTaxRate(0).Text, "0.00")
    5.         Case 1
    6.             lblTotalsAndTaxes(6).Caption = Format(txtTaxRate(1).Text, "0.00")
    7.     End Select
    8. End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width