Update table with form information

  • Thread starter Thread starter lecaballero
  • Start date Start date
L

lecaballero

Hi all,

I know it's a newbie question but anyway:

I have a table called "clasificacion"
Another one called "clasificacion_temp"
I also have a subform with a query related to "clasificacion_temp"

The user is supposed to enter the information in the textboxes and,
with a button, a macro will run an Add Query to populate from
"clasificacion_temp" to "clasificacion".

The problem is that the added data in "clasificacion" is not the one
that the user has just entered in the textboxes, but the previous
one.

Have I to code something like recordset.clone or recordset.close?

Do you know where can I find a basic guide to learn more about
recordset.Update/clone/close/etc?

I come from Excel VBA and I'm getting mad
 
It sounds like you simply need to save the record first.
DoCmd.RunCommand acCmdSaveRecord
or
If Me.Dirty Then
Me.Dirty = False
End If
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a value from subform or main form to subform query 4
Data entry for a table from a form 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Textbox to Textbox!! PLEASE HELP 17
populate to a table or query 3
New record in subform 2
Delete table information 6
HasData on a form? 3

Back
Top