Insert textbox value from a form into a table

Question

I have a textbox(in form) and a field(in table) both named SerialNumber

This is the control source of the textbox: =([OrderNr] & (""+[Aantal]) & "" & [SapArtNr])

I can't seem to make the textbox save the value inside into the table.

Edit:

Option Compare Database

Private Sub Command82_Click()
    ' Add data to Table
    CurrentDb.Execute "INSERT INTO Geleidelijst(SerialNmbr, InvoerOrderNr, InvoerAantal, InvoerVermogen, InvoerHSLSSpn) " & _
            " VALUES(" & Me.SerialNumberLong & ",'" & Me.OrderNr & "','" & _
            Me.Aantal & "','" & Me.Vermogen & "','" & Me.HSLSSpn & "')"
End Sub

But then I get error: 3075 Synax error missing operating in query expression. And if I add date as a format it doesn't work either.

Only when it's numbers, but when there's letters and dots and "/" for example, it won't work.

Any help would be nice, thanks.

You assign the expression to a read-only textbox as its ControlSource. That won't update a table field. — Gustav
– Gustav, Commented Jul 27, 2022 at 20:39
@Gustav Yeah thanks, I've tried different methods but still no success, updated the post. — SeeeeS
– SeeeeS, Commented Jul 28, 2022 at 6:09

Gustav · Accepted Answer · 2022-07-28 09:11:00Z

1

Most likely, Aantal is numeric, so try without quotes:

CurrentDb.Execute "INSERT INTO Geleidelijst " & _
    "(SerialNmbr, InvoerOrderNr, InvoerAantal, InvoerVermogen, InvoerHSLSSpn) " & _
    "VALUES('" & Me.SerialNumberLong & "','" & Me.OrderNr & "'," & Me.Aantal & ",'" & Me.Vermogen & "','" & Me.HSLSSpn & "')"

edited Jul 28, 2022 at 9:11

answered Jul 28, 2022 at 8:42

Gustav

56.4k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SeeeeS Over a year ago

Thanks for your answer, I could also try this with one textbox (SerialNumberLong), which is the important one. It conaints this value in the textbox: "23423423Q1000NB309 21/0.4 5I" But even with the code you sent I still get the error: "3075 Synax error missing operating in query expression

Gustav Over a year ago

That serial no. is text. See edited answer, please.

Collectives™ on Stack Overflow

Insert textbox value from a form into a table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related