numbrel wrote: But that seems to be about taking DateTime and manipulating it to get the string values desired. If that were the case, the method would be called .ToString(). DateTime.Parse() takes a string, and optionally, a format provider for some guidance, and returns a .NET DateTime object with the numerical version of the date and time. If the user is entering date and time seperately, you can combine them and submit the new date/time string to the Parse method: dtmDate = maskDate.FormattedText dtmTime = maskTime.FormattedText Dim myDateTime As DateTime = DateTime.Parse( dtmDate & " " & dtmTime ) The .Parse() method assumes that the full date and time are provided in the current culture, which on default US machines is "mm/dd/yyyy hh:mm:ss". If any information is missing, the default action is to replace the missing information with the current date/time info. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Thank you, exactly what I needed.

Thank you. Now on to solve the next problem that comes up. :^)

Do u mean that u got 2 combobox, 1st lists organisations, 2nd lists events sponsored by selected organisation in 1st ComboBox? If so; I think u have two tables, one has organisations list, others has events then assume two table is related to each other with OrganisationID. 1. Warn = use Just ONE DATASET, if not, it s painful. ============================================================================ Imports System.Data.SqlClient Public Class frmOrganisationsAndEvents Inherits System.Windows.Forms.Form ' On Form There is two ComboBox named cmbOrganisations and cmbEvents Dim cnOE As New SqlConnection("") Dim dsOE As New DataSet Dim dRowOE() As DataRow Private Sub frmOrganisationsAndEvents_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim adpOE As New SqlDataAdapter("SELECT * FROM Organisations", cnOE) adpOE.Fill(dsOE, "Organisations") adpOE.SelectCommand.CommandText = "SELECT * FROM Events" adpOE.Fill(dsOE, "Events") For i As Short = 0 To dsOE.Tables("Organisations").Rows.Count - 1 cmbOrganisations.Items.Add(dsOE.Tables("Organisations").Rows(i)("O_OrganisationName")) Next If Not cmbOrganisations.Items.Count = 0 Then cmbOrganisations.Text = "Select an Organisation" Else cmbOrganisations.Text = "No Organisation Installed" End If End Sub Private Sub cmbOrganisations_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbOrganisations.SelectedIndexChanged If Not cmbOrganisations.Items.Count = 0 And cmbOrganisations.SelectedIndex = -1 Then cmbEvents.Items.Clear() **'Events SubSet** drowOE = dsOE.Tables("Events").Select("E_OrganisationID=" & dsOE.Tables("Organisations").Rows(cmbOrganisations.SelectedIndex)("O_OrganisationID")) If Not dRowOE.Length = 0 Then For i As Short = 0 To dRowOE.GetUpperBound(0) cmbEvents.Items.Add(dRowOE(i)("E_EventAlias")) Next cmbOrganisations.Text = "Select Event Sponsored by " & dsOE.Tables("Organisations").Rows(cmbOrganisations.SelectedIndex)("O_OrganisationName") Else cmbOrganisations.Text = "No Event Installed Sponsored by " & dsOE.Tables("Organisations").Rows(cmbOrganisations.SelectedIndex)("O_OrganisationName") End If End If End Sub Priv

Thank you, Robert. I have been working on it and between two VB.NET books I was able to figure out how to use select method to form a subset. You are right about using select, it was much simpler than what I had originally thought to do. I was going to use the index (if it existed) and move through the data table to find the rows I wanted.

numbrel wrote: in the dataset, the Time field shows "12/30/1899" for every record DateTime in Access is stored as a double (DBTYPE_DATE) with the whole number portion representing the number of days since 12/30/1899. If you're only storing the time, the whole number portion will always be zero. After the value is converted to System.DateTime, you can get a TimeSpan representing the time of day from the TimeOfDay property. In a DataGrid, you can apply a DataGridTableStyle with a DataGridTextBoxColumn with the Format property set to "t" or "T" to display only the time portion. Charlie if(!curlies){ return; }