Table Within a Form - Selectable

[BrianB75]

Please forgive me if the following is confusing.

I am setting up a form that contains a table in datasheet view as a subform within the main one. This table will be at the bottom with about 20 fields at the top. The fields at the top match the fields in the form. What I want to do is allow the user to select a record in the table and have it automatically populate the fields at the top with that record's data.

Is this possible?

Also, is it possible to color code individual records based on certain criteria?

Thanks you in advance,
Brian

 

[WayneRyan]

Brian,

To keep your forms in synch, use the Master-Child relationships when you
have your form in design view. You can use search here (look for Master)
and you should find some examples.

You can use Conditional Formatting if you have Access 2000 or above.
Again search here for Conditional, you'll find examples.

Wayne