codequirks
Programmer
Hi there
I have a relatively simple form which is populated by a record source. The record source is an SQL statement defined in code in the Open event (see code below). The form loads all the records nicely but I cannot edit any of the fields!!
All the fields are enabled and not locked, the form allows edits, data-entry, has recordset type of dynaset and no record locks. Does anyone know why I cannot edit any of these fields???
Ideally I would like the user to be able to edit the fields and then click a save button to send the updates. I can handle the save bit but it is completely useless if the user cannot edit the data!!!!
Thanks for your help
Open Event..
'Define Variables
Dim StrSQL As String
'Set String
StrSQL = "SELECT Customer.ID, Customer.Name, Customer.Problem FROM ActiveCustomers;"
'Set the record source to be the SQL query
Me.RecordSource = StrSQL