ms access course - Synchronising forms

The UK's most regular instructor-led training courses.
Training information: ms access course · Access training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Synchronising forms

John has attended:
Word Advanced course
Outlook Advanced course
Excel Advanced course

by - delegate John [1 post] (2006 Nov 14 Tue, 19:55) Reply

I have a form that has a control button which opens a subform. I am having difficulty synchronising the records to show they are from the same client. Any tips / suggestions?

Thanks John

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jun 5 Thu + 6 Fri	Southwark	4	book now	£475	£485
2003/XP	2008 Jul 10 Thu + 11 Fri	Southwark	7	book now	£345	£399
2003/XP	2008 Aug 7 Thu + 8 Fri	Southwark	7	book now	£345	£399
2003/XP	2008 Sep 4 Thu + 5 Fri	Southwark	5	book now	£450	£485
2003/XP	2009 Jan 8 Thu + 9 Fri	Southwark	8	book now	£275	£399
2003/XP	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Synchronising forms

by - trainer Garry gold contributer [188 posts] (2006 Nov 15 Wed, 10:46) Reply

1st try to recreate the form using the form wizard and see if this will work
access is very unstable when you edit a same client

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access Courses
· How Reorganising Your Data Can Take Your Business to the Next Level

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

ms access course - Synchronising forms

Related articles

Access tip:

Copy a Previous Record's Values to a New Record