[AccessD] Create link between unbound mainform and subform

John Colby jcolby at colbyconsulting.com
Fri Oct 24 07:47:47 CDT 2003


Actually what you do is in the subform link master fields property simply
place the name of the control (text box usually) that contains the data for
the PK of the parent form.  Then place the FIELD NAME of the related FK in
the Link Child Fields form.

You may have to requery the subform when the main form changes, but try just
changing the text field and see what happens.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Sad Der
Sent: Friday, October 24, 2003 7:09 AM
To: Acces User Group
Subject: [AccessD] Create link between unbound mainform and subform


Hi group,

I'm using A2K. I've got an unbound form (fDetailMI).
On this form I've got a subform (fComments).

The subform is bound to the table tblComments
The mainform is not bound.

How can I link the subform to display the data for the
current record at the main form?

I already tried using a query as a record source for
the subform. The query has a parameter that references
an ID on the main form. Somehow this doesn't work?

Any ideas?

Regards,

SD



__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list