DoCmd .Save

[singingshiver]

I need to create a DoCmd .Save rule so that I tell a form which table to save the data to.
Any help on this? The form is called SFI Learning and the table it needs to save to is called SFI learning.


many thanks

 

[Newman]

There must be a better way, but something you could try if no one else answer is:

DoCmd.RunSQL

Must be able to work with SQL language and I ain't an expert at it. It's something like this:

"INSERT INTO «table name» SELECT " & «textbox name» & " AS «field name»;"

I havn't test this, so use it in a copy first.

 

[singingshiver]

any other ideas?

 

[yellow]

Yeah, don't ask the same question in 3 different (or more) posts, making me type a reply when it's already been answered somewhere else.