Not append the last field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I have a form based in T_Plans table and a subform based in Q_Proc query.
This SubForm has a Yes/No field.

In this SubForm there are a command button to run an AppendQuery to save in
T_Dest.

All fields of all records are normally in T_Dest, exception to Yes/No field
of the last record.
This field is saved in T_Proc (originary table of this field).
I would like any idea to detect the error.
Thanks in advance.

an
 
Hello "an".

an said:
Hi!

I have a form based in T_Plans table and a subform based in Q_Proc
query. This SubForm has a Yes/No field.
In this SubForm there are a command button to run an AppendQuery to
save in T_Dest.
All fields of all records are normally in T_Dest, exception to
Yes/No field of the last record.
This field is saved in T_Proc (originary table of this field).
I would like any idea to detect the error.
Thanks in advance.
Click to expand...

You probably should save the last record before appending the records:
DoCmd.RunCommand acCmdSaveRecord
 

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

Suggestion for Append 3
Modifying/Appending records between subforms 2
Appending records to new table using field names as values 2
Retrieving data from subform 1
Append only Null records in table 2
How to filter a child field combo box? 7
SetValue for fields on a bound subform 1
If field =15 save in two tables 2

Back
Top