Command button on Form to copy text box data to table field

[JMac]

Hi all
I have a need to place some generated data that resides in a text box on a form into a field in a table using a command button. The code is obviously wrong here but I was starting with the following..

Private Sub Command_Click()
Me!Textbox = ?? TableFieldname
End sub

What do I need to replace the ?? with? or am I way off target?


Cheers
Jon

[aytee111]

The button would need to run an Update query.

[pbaldy]

Alternatively, open a recordset and use the AddNew or Edit methods as appropriate.

[JMac]

The button would need to run an Update query.

I went with this method mainly as Id not worked with record sets before. It worked beautifully right up until I added the final crucial expression to the 'update to', ie the record number, and it came back with the error 'type coversion failure'
As this incremental number is critical how can i get around this??
Cheers

[raton]

1. generated data that resides in a text box on a form.
2. make a textbox in the form, which control source is table field. data default value, forms!formname!generated textbox name
3. generated textbox lostfocus event
private_sub generated textbox lostfous
textboxname(which control source is the field name) = generated textbox name
end sub
4. invisible the table field textbox

[aytee111]

Post your SQL/code