InputBox Function

coley

Coley
Local time
Today, 03:29
Joined
Feb 22, 2005
Messages
39
Hi

I need help as I have hit a brick wall.

I can create the Inputbox fine, what i need to know is how to update what the user enters in the input box to my table.

Many thanks

Coley
 
If you called the following code from a command button it will enter what ever you type in the input box into the control on your form named "txtMyControl"

txtMyControl = InputBox("Please Enter Text", "Input Box")

If that control is linked to a field in your database it will enter the data into that field.
 
Using a field as Gizmo described is easiest... but if you really wanted to, you could save it as a string... and use an "UPDATE" or "INSERT INTO" query to update your table.
 

Users who are viewing this thread

Back
Top Bottom