Problem With Sub Form

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

(Access2003) I have an existing 2 page form on which the master link field
is called "MnSum.Project Ref", using the SubForm Wizard I have incerted a
second form (datasheet view) with a child field of "Project Ref". (On this
child form there are just 3 fields "Date", Time Spent" and "Project Ref". I
have set the default value of "Project Ref" to
"=[Forms]![Bnew]![MnSum.Project Ref]".

The form looks just as I would like and as you change from one sheet to
another the two forms remain in sinq.

The problem comes when you try to add an item to the child form. when you
click on date, you get the message " The Link Master Fields Property
setting has produced this error "The Object does'nt contain the Automatic
object MnSum". Howerver if you click on ok, it lets you carry on and add
records to the child form?

Can anybody assist with this issue please.

Bob
 
i don't know if this is the cause of your problem, but you shouldn't have to
set the DefaultValue property of the ProjectRef control in the subform. in a
correctly linked mainform/subform, the foreign key field in the subform
should automatically be filled with the primary key value from the current
record in the main form - without any special programming or intervention on
your part.

hth
 
Back
Top