Question Locked

Access - Relationships

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am currently putting together a database and I have set up a relationship between forms, the problem is the information from the master form is not carried over to the sub form I have searched the help section and they refer to LinkMasterchild, I have followed their instruction and cannot find the fields, anybody now how? Also can one instruct&how access to do the following: if a date has expired to change the font colour, etc.

3 replies

by john.a.wills

In the subform properties are to be found link child fields and link master fields. In these you should write the names of the child and master fields which are to match up.

by john.a.wills

Each control has a property back color and another property fore color and yet another property border color. These may be changed in VBA thus: ctrlname.ForeColor = vbBlue.

This discussion is closed to new replies.