Re: Copy Record With VBA (Access 2000)

=?Utf-8?B?V0NS?= <WCR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:0F6A3966-52B9-400E-A21B-AA42F91728BD@xxxxxxxxxxxxx:

> Let's say, hypothetically of course, that I had a
> table with 10 fields, and I wanted to allow the user the option of
> creating a new record with default values for 8 of these fields from
> an existing record.
> How would I do this?
>

You wouldn't. If the eight field go together, then they should be in a
single record in another table; then you would set one value to point to
that record.

Can you provide details of what you are _actually_ trying to achieve? As
you are discovering, taking bad design decision in the name of trying to
"keep things simple" usually ends up in far more complication and error.

All the best


Tim F


.

Relevant Pages