data linked forms
Posted on 2001-06-13
Hi. I'm trying to write a database program in VB. However, there is one form which cannot hold all the information on it at the same time, so I created a second form to hold the rest of the info. The problem is that on the first form, there is a data control which is used to scroll through the different records. How do I make it so that when I scroll, the information on the second form also scrolls with it (i.e. if i bring up the second form, the info on the second form will match the record displaying on the first)?
I tried doing the following, but it's giving me an error, "Invalid use of null". Can someone help me fix this please?
txtPayment.DataField = txtEnterInvoices.dbFairbanx.Recordset.Fields("PYMNTRCVD")
txtPaymentDate.DataField = frmEnterInvoices.dbFairbanx.Recordset.Fields("PYMNTDATE")