By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,201 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Linking Subforms

P: 3
Hi all,
In our work DB I want to be able to link 2 continous forms together using an ID.
So far I have created both the forms and made them continous forms. I then opened a blank form and inserted both the forms as individual subforms. However I need to link both these forms together.

It has be suggested that I link them manually, but I don't know how to do it. I have limited access programming knowledge.
Any help would be appreciated.

Thank,

Ken
Sep 12 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 296
Hi all,
In our work DB I want to be able to link 2 continous forms together using an ID.
So far I have created both the forms and made them continous forms. I then opened a blank form and inserted both the forms as individual subforms. However I need to link both these forms together.

It has be suggested that I link them manually, but I don't know how to do it. I have limited access programming knowledge.
Any help would be appreciated.

Thank,

Ken
In your form design view, look at the properties, and under the Data tab, it will say Link Child Fields and Link Master Fields. Click on each of those to link the forms by the ID. Since you're using a one main form, the ID will need to be on the main form as well as both subforms. If you're not wanting it visible on each of them, set the property Visible to No. You will be linking the subforms to the main form using this method.
Sep 12 '07 #2

P: 3
Thankyou for getting back to me.
How do I put the ID onto the blank form?
Do I create a text box and name it ID?
I'm just not sure how to do this.

many thanks,
Ken
Sep 12 '07 #3

Expert 100+
P: 296
Thankyou for getting back to me.
How do I put the ID onto the blank form?
Do I create a text box and name it ID?
I'm just not sure how to do this.

many thanks,
Ken
You're gonna have to have your main form bound to a query or table. You can create a simple query that includes any/all fields that you want displayed on your main form, including the ID field. Once that query is created, bound your main form to it, and then to add the ID field to the main form, you can select it from the Field list and drag it into place onto your form.
Sep 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.