displaying current record in a subform

V

vandy

I have a form that has a subform linked to it. It is a continuous form. How
to make is display the current record. Right now if there are 2 records in
the subform for the transaction i have to use the record selector to display
the the 2 record. can it display the current new record. i know in datasheet
view i should be able to get 1 and 2 records if it is populated can this be
done in continous form.

Thanks in advance
 
M

Mark A. Sam

Vandy,

Click on trhe subform control. There are properties called LinkMasterFields
and LinkChildFields. The mainform subform needs a common field to match up
the records, such as MainTableID. If MainTableID is an autonumber and
primary key for example, you would need the same field in the subtable with
the same datatype, in this case a long integer.

In this example, you would enter MainTableID as the LinkMasterFields and
LinkChildFields values. This will synchornize the forms.

God Bless,

Mark A. Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top