HELP

[giggs11]

I am new to VB and need help.


I have designed a sales tracker. Form 1 has the Agent's Name, Date, Customer Name and Product type. This info is submitted to my data base by a command button. That works fine. I have a second form that is loaded by a second button. This form has a Date field and multiple Customer Name, Date and Product type fields. Basically what i want to do is submit the info enterd on the first form into this second form. The question is...How do i program it so that it knows to enter the info on the next empty row?


Thank you,

Simon

 

[MikeCox]

If you're using the Ado Data Control on the second form you can call Adodc1.Refresh after adding a new agent from the first one. That'll requery the database based on the criteria u specified at design time, and will include the new record as well.

Hope that helps!

~Mike Any man willing to sacrifice liberty for security deserves neither liberty nor security.

-Ben Franklin