Private Sub NavigateRecords()
txtCustomerName.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("customername")), "", ds.Tables("customer").Rows(inc).Item("customername")).ToString
txtCustomerNumber.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("customernumber")), "", ds.Tables("customer").Rows(inc).Item("customernumber")).ToString
txtCustomerAddress.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("streetaddress")), "", ds.Tables("customer").Rows(inc).Item("streetaddress")).ToString
txtCustomerAddress2.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("streetaddress2")), "", ds.Tables("customer").Rows(inc).Item("streetaddress2")).ToString
txtCustomerPOBox.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("pobox")), "", ds.Tables("customer").Rows(inc).Item("pobox")).ToString
txtCustomerCity.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("city")), "", ds.Tables("customer").Rows(inc).Item("city")).ToString
txtCustomerState.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("state")), "", ds.Tables("customer").Rows(inc).Item("state")).ToString
txtCustomerZip.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("postalcode")), "", ds.Tables("customer").Rows(inc).Item("postalcode")).ToString
txtCustomerContact.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("contact")), "", ds.Tables("customer").Rows(inc).Item("contact")).ToString
txtCustomerPhone.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("contactphone")), "", ds.Tables("customer").Rows(inc).Item("contactphone")).ToString
txtCustomerNotes.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("notes")), "", ds.Tables("customer").Rows(inc).Item("notes")).ToString
txtCustomerLastUpdate.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("lastupdate")), "", ds.Tables("customer").Rows(inc).Item("lastupdate")).ToString
txtCustomerUpdatedBy.Text = IIf(IsDBNull(ds.Tables("customer").Rows(inc).Item("updatedby")), "", ds.Tables("customer").Rows(inc).Item("updatedby")).ToString
Try
txtCustomerName.Text = ds.Tables("customer").Rows(inc).Item(0)
txtCustomerNumber.Text = ds.Tables("customer").Rows(inc).Item(1)
txtCustomerAddress.Text = ds.Tables("customer").Rows(inc).Item(2)
txtCustomerAddress2.Text = ds.Tables("customer").Rows(inc).Item(3)
txtCustomerPOBox.Text = ds.Tables("customer").Rows(inc).Item(4)
txtCustomerCity.Text = ds.Tables("customer").Rows(inc).Item(5)
txtCustomerState.Text = ds.Tables("customer").Rows(inc).Item(6)
txtCustomerZip.Text = ds.Tables("customer").Rows(inc).Item(7)
txtCustomerContact.Text = ds.Tables("customer").Rows(inc).Item(8)
txtCustomerPhone.Text = ds.Tables("customer").Rows(inc).Item(9)
txtCustomerNotes.Text = ds.Tables("customer").Rows(inc).Item(10)
txtCustomerLastUpdate.Text = ds.Tables("customer").Rows(inc).Item(11)
txtCustomerUpdatedBy.Text = ds.Tables("customer").Rows(inc).Item(12)
Catch ex As Exception
MsgBox("Returning Null Values")
End Try
End Sub