Copy and paste automatically in Access Form

[Guest]

I need some guidance in a form and subform I built in Access. I want to copy
a line of data from my original form and then paste it to the subform
automatically. It seems like there should be an easy way to accomplish this
with a button and some coding. All the fields in the form and subform are
identical and it is possible to do it by hand, but it would be easier to just
have users be able to click a button and have the info copied into the
subform automatically.

Any information at all would be helpful. Thanks

 

[Douglas J. Steele]

Why? The implication is that you'll have the same pieces of data stored
redundantly, not a desirable thing in a relational database.

Perhaps you can explain a little more about what you're trying to
accomplish.

 

[Guest]

It's someone else's database, I was just trying to find out this piece of
information from them. Is there indeed a way to do this...even if it is
redundant, can't you just tell me how? Thanks.

 

[Douglas J. Steele]

The best approach is not to do a copy-and-paste, but to use a query to take
the data from the table that's populating the parent form, and write it to
the table that's populating the subform.

Well, the best approach given that you shouldn't be doing it! <g>