 |  |  |  |  |  |  |  |
passing data from form1 to form2
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
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: 55
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
Views: 1733 | Replies: 4
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection copy creat ctrl+f data database datareport date delete dissertations 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 retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
