Forum home » Delegate support and help forum » Microsoft Access Training and help » Synchronising forms and subforms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Synchronising forms and subforms
Resolved · Medium Priority · Version 2007
Reply Fri 12 Aug 2011, 11:33Lorna (guest) said...
Synchronising forms and subforms
Hi there,
I created several tables and related them correctly (I think) and from this I've created the main form that we're going to use to enter data. On the form there are a number of subforms and I can't seem to get these to synchronise.
For example, we have a subform which details the organisation's general details. We record the individual person's contact name and details on the main form to go with that individual record, but I thought the organisation details (company name and address) could be kept seperately as there may be multiple people from the same organisation applying, who would each require their own individual record.
I tried filling in the first record and then went to a new blank record, but the organisaton details subform carries with it the information from the first record. As far as I can see all the other subforms are synchronised but I'm not sure how I've done this.
How can I make sure all subforms are synchronised to the main form so that when I select a new record every field is blank?
Many thanks,
Lorna
For upcoming training course dates see: Pricing & availability
RE: Synchronising forms and subforms
Hello Lorna,
Re: Forms and subforms
Without seeing the actual forms can be difficult to see why its not working. However, you could try this. You should have 2 seperate forms made up, one the primary form, and a secondary form, the subform. These are both seperate at this stage. Open the Primary form in design view. Then drag and drop the subform into this primary form where it needs to go, this will automatically link the two. If not, then we need to look further at the database structure.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
Thu 18 Aug 2011: Automatically marked as resolved.
|