Auto-fill Subform Reference

[z.ghulam@gmail.com]

Hi,

I have a subform in a main form.
When I create new records in the subform I would like the Subform.
[Issue Ref] to autofill with the MainForm.[Ref]
It sounds quite simple, but ive been bustin my brains trying to get
it
to work with no success.
The LinkChild / Master fields seem to be set up correctly, as only the
subform records for that particular Ref are being shown.
Link Child Field = Issue Ref
Link Master Field = Ref

I just cant get the Subforms Issue Ref to autofill.
Any ideas?

Cheers
Zieshan

[ruralguy via AccessMonster.com]

Re: Auto-fill Subform Reference

Try including these fields in your LinkChild / Master fields and Access will
complete them for you.

z.ghulam@gmail. com wrote:

>Hi,
>
>I have a subform in a main form.
>When I create new records in the subform I would like the Subform.
>[Issue Ref] to autofill with the MainForm.[Ref]
>It sounds quite simple, but ive been bustin my brains trying to get
>it
>to work with no success.
>The LinkChild / Master fields seem to be set up correctly, as only the
>subform records for that particular Ref are being shown.
>Link Child Field = Issue Ref
>Link Master Field = Ref
>
>I just cant get the Subforms Issue Ref to autofill.
>Any ideas?
>
>Cheers
>Zieshan

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com