\r\n\r\n \r\n \r\n \r\n # 3 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n  \r\n \r\n 09-14-2000, 05:18 AM\r\n \r\n \r\n \r\n | \r\n
\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n\r\n \r\n\r\n Guest \r\n \r\n \r\n\r\n | \r\n | \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n Posts: n/a\r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n \r\n | \r\n
\r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n  \r\n Re: Need a Grid?\r\n
\r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n\r\n \r\n\r\n\r\n Hi,
\n
\nI wouldn\'t allow the user to directly edit the table, rather use a textbox and command button for data entry. I think I got somewhere close to what you\'re after by using a DataGrid Control bound to an ADO Data Control.
\nSetting the "allow update" property of the DataGrid to False ensures the user cannot directly edit the grid. text typed into a textbox can then be used to update the grid using a command button as in
\n
\nPrivate Sub Command2_Click()
\n\'
\n DataGrid1.Col = 1
\n DataGrid1.Text = Text1.Text
\n
\nEnd Sub
\n
\nThis code updates the second column of the selected record in the grid which automatically updates the database
\n
\nGood Luck
\nPhil
\n
\n \r\n \r\n\r\n | \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n  \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n
\r\n
\r\n\r\n\r\n
Threaded Mode
