I have two problems
1. I have two tables which are linked. now I want if I open the child table to also display the valus of a field in the master table automatically. e.g table A has field Unit number, Name(PrimaryKey Unit Number) table B has fields Unit Number, Result. the two tables are linked by Unit number. now when I want when I enter the Primary field values they are automatically populate Unit Number field in table B. I dont want to re-enter the PrimaryKey field value when I want to make entries in Table B

2. I have put VBA code in the form current to be executed when the form is started. Now, I have found that the code is executing correctly in some records but not in others. What is the problem. e.g as I navigate through the records by the forms. In some it calculates correctly but in others not
Help

Bmulenga

__________________
Bmulenga

Hiya,

   As to 1., you don't need to move the value to the other table. Just refer to the value when you need it in queries and reports by referring to the other table by the FK. This is a standard design technique.

   If you really need to capture the value, then you will need to code this on a data entry form.

   What is the code for 2.?





mmcdonal