New Record using Input Box?

[sentient_amoeba]

Hello!

I know only a bit of code at the moment.

I'm trying to add a new record to a table by using an Input Box prompt. I can get the Input Box to appear, but how do I enter my value as a New Record?

Thanks very much!

 

[ghudson]

Unless your record has only one field...I do not think that you can add a new record with the value from an input box.

Are you trying to update a field within a record with the value from an input box?

If so, try this....

Dim strInput As String
Dim strMsg As String

strMsg = "Update the 'Test' field?"
strInput = InputBox(Prompt:=strMsg, title:="Update?")
Me.YourTextBox.Value = strInput

HTH

 

[sentient_amoeba]

Thank you!

Thanks ghudson!