Home > database >  By VBA executed, see table have been recorded. But form also suggests there is no relevant records!
By VBA executed, see table have been recorded. But form also suggests there is no relevant records!

Time:09-28

Such as:
A form binding a table, click on the button to perform after the event: box score has been recorded, but, the form also hint: index and primary key can't be empty,
However, as specified by the table already has related records,
Which prawn to refer to a road,

Perform the vba function:
Sub TjRkID (Myid As String, RQ As the Date, Bm As String) 'warehouse ID is added to the inventory table
Dim the rs As you, strtemp As String
Strtemp="Insert into ck_ inventory list (warehouse id, date, department) values ('" & amp; Myid & amp; "', '" & amp; RQ & amp; "', '" & amp; Bm & amp; "')
"CurrentProject. Connection. The Execute strtemp
End Sub

CodePudding user response:

This is, what kind of problem?

CodePudding user response:

Moderator smoke kung fu to see bai,
  • Related