Default value in a form field from another table

[yoshi88]

Hi,

I have two tables link together with the employees number. The first one, Schedule_defaulft, has one record per employee with their default schedule, the one they usually have. The second one, Schedule_week, has multiple records per employee, each records are their real schedule for a particular week.

Is it possible that when I add a new record for a new week in Schedule_week, the default schedule in Schedule_default will be put as the default value in every field ?

Thanks

Frank

 

[wonderwhy]

Frank,

If you are viewing the Schedule_week form as a subform to the Schedule_default form then I would reference the field value from the Schedule_default form in the Default Value property for each field in the Schedule_week subform. For example, type the following for the Default Value in each field where you want to use the value from the main form.

=[Forms]![NameofMainForm]

I'm sure someone will have a better solution but this might help in the meantime.

If you are not using a mainform/subform you will need a different solution.

Julia