**Currently the DoCmd.Close is commented out.
Expand|Select|Wrap|Line Numbers
- Private Sub SaveInput_Click()
- Dim InputString() As String
- Dim i As Integer
- InputString = Split(InputName, " ")
- For i = 0 To UBound(InputString)
- CurrentDb.Execute "INSERT INTO InventoryInputT(InputID) VALUES ('" & InputString(i) & "')"
- Next i
- 'DoCmd.Close acForm, "InventoryInputF"'
- End Sub
field1 data1
field2 data2
field3 data3
My perplexing issue is, if I uncomment the DoCmd.Close acForm."InventoryInputF" which I wrote purely to close the form after saving.... it table now displays the results
field1 data1 data2 data3
field2 data1
field3 data2
field4 data3
You can see that for some reason when I implement the docmd.close code, the data is saved both as its 'lump sum' of all the values IN ADDITION to its proper function of using the split() function.
Anybody have any ideas why? Or maybe another way to close my form with code so I can avoid the DoCmd.Close code??