field names don't match names on form

[webmeister]

I have a form with several data fields on it. I also have a button on the form that allows the user to duplicate a record . The reason for this duplication is so that if there will be an additional client record for the same customer, but only one piece of data will need to be changed, it's easier to copy the record and then change the one field.

However, I am getting the following message:

"some of the field names you tried to paste don't match fieldnames on the form"

and then not all data in all fields gets duplicated.

I need to figure this out, but am going nuts with it. If anyone has an idea or two they'd care to toss my way, I would be happy.

Thanks one more time, in advance!!

 

[Leopardfist]

Are you trying to copy the record to the SAME Table or a new table?

If it is the same table, simply use the Command Button wizard. Just be careful to not copy the Primary Key in the process, that will cause an error due to duplicate values.

If you still get the error, using the above technique, ensure that your controls names on your forms match the fields on your tables, that is my only idea if the wizard doesn't work. You can also check the formating of the controls on the form, make sure they match the format of the field in the table... for example date/time on the table, and text on the form, will cause data to get messed up, I learned this the hard way.