Select Subform Records to Append 1

[mbarkley9872]

I've posted this question as part of a bigger issue on the Other Topics forum thread 181-1341594. I haven't had any response there so I thought I'd post this sub-question here...

If I have...

tblMR_Ex:
- MR_ExID PK
- Tail
- Date
- ATA

tblMR_Ex180:
- MR_Ex180ID PK
- Tail
- Date
- ATA

tblMR_ExHist:
- MR_ExID FK
- MR_Ex180ID FK

frmMR_Ex – recordsource is tblMR_Ex
sfmMR_Ex180 – recordsource is tblMR_Ex180; linked to frmMR_Ex by [Tail] and [ATA]

How can I select 1 or more records (or none) in sfmMR_Ex180 and append [MR_Ex180ID] and [MR_ExID] (from the main form) to tblMR_ExHist?

Thanks for any assistance!

Mike

 

[mbarkley9872]

I've reviewed hundreds of threads looking for some ideas on this. So far all I've seen is using a checkbox as the criteria for the records to be appended.

Is this the best method? If so, what would be the best way to clear those boxes after the append? If the user goes to next record (and it has same Tail and ATA), the records in subform should not be checked. However, if user goes back to previous record, he would no longer know which records were appended since the checks would have been cleared.

Thoughts?

 

[MajP]

I posted a possible solution in you original post.