 |  |  |  |  |  |  |  |
passing data from form1 to form2
 |
Dear friends,
i want to pass data from one form to another form which is having back end ms access table1 for form1, table2 for form2 connected to forms with databound controls data1.
my problem is while entering data in text1 of forms1, it should go to text1 of form2 auto matically and should be updated. iam using following code for linking and updating data
in lost focus event of text1 in form1
form2.data1.recordset.addnew
text1.text=form2.text1.text
form2.data1.recordset.update
form2.data1.refresh
end sub.
data is being transferred to form2, text1 and also ms access table.but somany rows are being created without any data in form2 database.
i request any body to correct this error and give me guidance
thanking you
i want to pass data from one form to another form which is having back end ms access table1 for form1, table2 for form2 connected to forms with databound controls data1.
my problem is while entering data in text1 of forms1, it should go to text1 of form2 auto matically and should be updated. iam using following code for linking and updating data
in lost focus event of text1 in form1
form2.data1.recordset.addnew
text1.text=form2.text1.text
form2.data1.recordset.update
form2.data1.refresh
end sub.
data is being transferred to form2, text1 and also ms access table.but somany rows are being created without any data in form2 database.
i request any body to correct this error and give me guidance
thanking you
Your way of updating record is not good...
A conclusion is the place where you got tired of thinking. http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
•
•
Join Date: Jul 2008
Posts: 53
Reputation: 
Solved Threads: 1
Junior Poster in Training
clear the datafield and data source text1 control of form2. and try. I hope it will work.
Haven't you tried debasi's suggestion?
Last edited by jireh; Oct 20th, 2008 at 8:38 am.
A conclusion is the place where you got tired of thinking. http://www.martin2k.co.uk/forums/index.php?showforum=4
http://www.a1vbcode.com/a1vbcode/vbforums/Forum3-1.aspx
http://www.developerfusion.co.uk/for...orum&ForumID=4
|
Similar Threads
- Please help with passing data from one form to another form (VB.NET)
- Passing data from a datagrid to textbox (Visual Basic 4 / 5 / 6)
- Passing parameter to datagridview (VB.NET)
- Passing data from a datagrid to textbox (Visual Basic 4 / 5 / 6)
- passing data between forms (Visual Basic 4 / 5 / 6)
- Passing data from datagridview to textboxes (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Need Help Calculating Days Active based on dates
- Next Thread: opening a database from vb6
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
