why the subform record source will change ?

[sallyGals]

example:
main form: frmDailyStatorEvaluation
- tblDailyStatorEavaluation
subform1: frmDailySupervisor
-- tblDailySupervisor
subform2: frmDailyPlan
-- tblDailyPlan


i set the child n master link to be mainform's dateEtstorEvaluation and subform1.date ; mainform's dateStatorEvaluation and Subform2.Date

all i had set probably..but the two subform also will become the same subform once i click the design view again..
izzit anythings that i need to do?>
thx..

best regards
sallyGals

 

[dhookom]

I can't understand what your issue or question are. Do you realize that date is a function and should not be used as a field name?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]