synchronising forms and subforms

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Synchronising forms and subforms

Synchronising forms and subforms

resolvedResolved · Medium Priority · Version 2007

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

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.


 

Access articles

Please browse our web site to find out more about
access+training and other training courses.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.