Hello , could anybody tell me how pull data from simple request SQL in the field of forms , thanks
here some code
Private Sub Form_Open(Cancel As Integer) '
dim strSQL as string
dim orderID as varint
orderId= 20
strSQL = "SELECT table.[ID_Excel] FROM table wHERE ID=" & OrderID
Debug.Print strSQL ' correct
Me.RecordSource = strSQL ' nothing happening actually here is issue
Me.поле0.value = strSQL '
' here wrote in field "select table.[ID_Excel] FROM table " instead of true value = 5000
end sub
Moderator Note:
Pls use code tags around your code next time as per forum rules.
Bookmarks