CANNOT PASTE DATA

[psychson]

Hi.
I'm having trouble with two tables. I'm trying to COPY and PASTE some data from one table to the other. The tables are an exactly match apparently, I check each field and they match. Once I COPY one table data and go to the next table to PASTE APPEND , it starts pasting and all of a sudden stops and I get this message:
"THE TEXT YOU ENTERED ISN'T AN ITEM IN THE LIST. SELECT AN ITEM FROM THE LIST OR ENTER TEXT THAT MATCHES ONE OF THE ITEMS."
So, I have no idea what ITEMS it's reffering to. I click OK, and I keeps telling me same thing for at least 4 OK's clicks. After I'm asked if I am sure I want to past such number of records, by then, only a porcentage of the records are copied, not all. If I say NO I do not want to copy, it still copies anyway, but again, not all the date, just a portion.
Would you have any idea how I can get this problem solved or how did I get into this mess anyway?
I'd appreciate it.
Thanks.
Sonia

 

[lameid]

The error you mentioned sounds like an error generated by a limit to list property being set. Design your target table. At the bottom where the field properties are, select the lookup tab instead of the general tab (Field sizee is on the general tab).

Look at Display control for each field. Any that say combo box or list box may have a "limit to list" property set to yes. Any of those may be the source of your problem. The row source will tell you what is being used for a list of possible values. Depending on your situation you may need to add values to the target tables list, or remove the list or make the limit to list property no.

Moving on to the next issue, copying and pasting. Sure I do it occasionally for one or two records but for a large number you are much better off using an append query... Make a new query, add the table you want to copy from and any or all fields you want to copy to the query. Next from the query menu, select append query. When prompted for a table to append to, select the destination table. Make sure your append to line at the bottom specify aprropriate fields. Finally running it by pushing the exclamation button on the toolbar will try to put the records in your table.