Duplicate Record Button not working

[Larry]

I wanted to duplicate a record on my form, so I thought I'd use the
Duplicate Record button that the wizard builds for you on the form. I
thought this would be simple, but something seems to be wrong. The
copied record is missing a couple of fields.

I simply put the button on my form and chose the Duplicate Record
macro. It copies almost all the data, but there are two fields (that
I've noticed so far) that are not copied.

Anyone know any reasons this might be happening?

I'm using Access 2003.

Thanks,
Larry

 

[Guest]

I assume you have checked the field properties to make sure duplicates are
allowed...

 

[Larry]

Yes, thanks.

The two fields have nothing special, one is a text field the other is a
numeric field.

 

[Larry]

This still doesn't work, does anyone else have any ideas?

 

[Guest]

Larry:

Just a thought...

Are the missing fields on the form? I've never used the Duplicate Record
function, but I could imagine that it only brings over the data that exists
on the form, directly. (Or in the Row Source).

Good luck.

Sharkbyte