TransferText

[NewEra]

I'm using a form that is connected to my main table. In the form you can search through and find anyone you want on the database. But when I add a button, I want it to grab the person's information on that form and put it into a different table. I'm having problems with it. Can anyone help me out?

 

[Rabbie]

You shouldn't be storing the same data in two different tables so I think you need to look at your design

 

[NewEra]

The information that I'm putting from one table to the 2nd table by the form is that the 2nd table is just certain people that got picked from a drawing. I just want to grab certain people's information.

 

[Rabbie]

The information that I'm putting from one table to the 2nd table by the form is that the 2nd table is just certain people that got picked from a drawing. I just want to grab certain people's information.

Thats what queries are for! Your forms should be always be based on queries anyway as it makes it easier to deal with changes later on.

Just add a field to your table to let you select the subset of data you need.

 

[NewEra]

OK thanks, but I have one more question. What code do I use for the button to add the new record to a different table? I tried transfertext but that doesn't work, I have been having problems with this for so long. Do you have any ideas? Thanks for the help.

 

[ajetrumpet]

have you worked with recordsets? You will need one to do this...

 

[NewEra]

I have no idea what recordsets are.

 

[ajetrumpet]

I'm not sure what to say, but you may want to look at the sample form and see if you can gather anything from that first.

It does what you are asking about...

 

[NewEra]

ajetrumpet thanks for the help by sending me that file. That is exactly what I want to do in my project. I'm trying to do what you have right there and this is what my code is but its still not working. But also when I run your form it doesn't work, it doesn't copy the record to the table you want it to copy to. I'll attach it to the form if you or anyone else wants to take a look at it.

 

[ajetrumpet]

If you eliminate the primary key from the "Turkey Hunters" table, it works fine. PK's cannot be duplicated...

 

[NewEra]

Cool it does say that it was copied to the other table but when I go to the turkey table there is nothing in there. But its wierd if you save it and close out of the project and then when I go back to the project all of the information that I wanted on there is on that table. Thanks a lot man that was something I was stuck on for the longest of time. Thanks for the help.