Re: Auto-fill Subform Reference

From: "ruralguy via AccessMonster.com" <u12102@uwe>
Date: Sat, 12 Jul 2008 15:14:20 GMT

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

z.ghulam@xxxxxxxxx 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

.

References:
- Auto-fill Subform Reference
  - From: z . ghulam

Prev by Date: Re: Why db.OpenRecordset("SQL STRING HERE", dbOpenDynaset) is not working ?
Next by Date: Re: Why db.OpenRecordset("SQL STRING HERE", dbOpenDynaset) is not working ?
Previous by thread: Auto-fill Subform Reference
Next by thread: RE: Incorrect display of values in Form !!
Index(es):
- Date
- Thread

Relevant Pages

Re: Subform Requerying
... Sylvain Lafontaine, ing. ... Personally, when the parameter for the subform is not the primary key, I ... use the Child and Master fields for a subform with ADP. ... also trigger a requery (and don't work well or at all with an EXEC ...
(microsoft.public.access.adp.sqlserver)
Re: Subform Requerying
... Sylvain Lafontaine, ing. ... Personally, when the parameter for the subform is not the primary key, ... use the Child and Master fields for a subform with ADP. ... also trigger a requery (and don't work well or at all with an EXEC ...
(microsoft.public.access.adp.sqlserver)
Re: Subform Requerying
... The subform will be requeried automatically if you set its RecordSource to ... Master fields for a subform with ADP. ... trigger a requery. ... Sylvain Lafontaine, ing. ...
(microsoft.public.access.adp.sqlserver)
Re: Subform Requerying
... Properties) a Record Source and Qualifier for the subform, ... In other words an unnecessary requery. ... Master fields for a subform with ADP. ... Sylvain Lafontaine, ing. ...
(microsoft.public.access.adp.sqlserver)
Re: Subform Requerying
... when you define a Child Field and Master Field that it does perform a requery ... assumed that I must take care of timing of subform requerying in code. ... Link Master fields as well as any Server Filter. ...
(microsoft.public.access.adp.sqlserver)