Add record via form?

[sasolini]

hey

Can someone pls tell me how to make this work?

I have a form that have a button on it to open a new form, then i select, write some data on that new form and when i click a button that data need to be transfered to a new (third) form as a new record. The problem that i have is that for some reason i can not make that new record so i allways get my data in first record. If that third forum would be closed i could use "on open" command but in my case that would not work. So can someone pls tell me how can i make this work?

Thx

 

[ColinEssex]

Personally, I'm confused by the third form. If you open a form from an opening screen and type in the new data, why would you transfer it all to another form?

Post your tables and fields, I sense that you may have more than you need, also, can you explain what your database is trying to do

Col

 

[sasolini]

hmm ill try...

It goes like this..

I have a forum1 and forum3 on one screen. Forum1 shows me a data i put in normali (write it). Next to those entries (every record is in new row) is a button for transfering data. (Forum1 represent Store1) When i press that button the new forum is opened (forum2) and there i select how many pices i want to transfer from store1 to store2 (forum3).

I have one table for forum1 and one table for forum2.

Everythink work just fine for me, the only problem is that i can not run add new record function for some reason. So the Q is still the same...how can i tell the form to add new record? Becouse if i click with the mouse on the new record ( the empty row - the last row) in form3 and than i click the button on form1, everythink works ok! The data is nicly placed in that new row just the way i want it.