Hi Chris128,
Here's the actual select statement; the Customer Info was used to keep the issue generic, but I suppose I could have done it this way with the same effect.
[code] SelectCmd.CommandText = "SELECT reported_user, reported_Support, outage_details FROM tOutagesServer WHERE Srv_Ticket = @Srv_Ticket"[\code]
The columns in the Select are from my database, the tOutagesServer is my Access table name, and the Srv_Ticket is the text box name on my form.




Reply With Quote