Values won't save unless changed

[crisis2007]

I have an input form that retrieves records from a table called T_Template. This input form is actually a subform on a main form (but not linked). I have the subform deliver the records to another receiving table (T_Event) by running an Append Query. It works fine for moving the records on the subform that I physically change. But for the records I don't change, the records do not pass into the receiving table. It is as if although I see the values in the records, the subform doesn't know they are there. Does anyone have any ideas on what I am doing wrong? The input form is intended to be a template for scheduling. Therefore even if there does not appear to be any changes needed, I want the values that appear in the records that are "defaulted" to pass to the receiving table.

I am still learning and can struggle through vba a little. I will greatly take any advice I can get.

 

[dhookom]

It would help if you provided the append query SQL and what is triggering it. Are you sure the record in the subform is saved prior to running the append query?

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

crisis2007 . . .

Is the subform bound to a table (query oe otherwise)?


See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[crisis2007]

As I looked at my problem further - I decided to change my design to get past the problem. But thanks for responding though.

 

[TheAceMan1]

crisis2007 . . .

To help prevent you from making so many [blue]major[/blue] changes ... why not have the pros at forum700 examine your design. They'll be able to give you tips you can't get anywhere else.

Also ... be sure to have a look at the following links:

Fundamentals of Relational Database Design

Database Normalization Basics

Defining Relationships Between Tables

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]