Hello , could tell me why i cant copypaste data from sql request in the field of the forms on Access here
Private Sub Form_Open(Cancel As Integer) ' dim strSql as string strSQL = "SELECT table.[ID_Excel] FROM table wHERE ID=" & OrderID Debug.Print strSQL ' correctMe.RecordSource = strSQL ' nothing happening Me.field0.value = strSQL ' wrote in the field SELECT table.[ID_Excel] FROM table wHERE ID=" ' and not value of the SQS for example 15000 end sub