ms access course - Synchronising forms

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

Resolved · Low Priority · Version Standard

1 post

ReplyTue 14 Nov 2006, 19:55Delegate John said...

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

Synchronising forms

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 Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£199	£204
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£75	£80
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

188 posts

ReplyWed 15 Nov 2006, 10:46Trainer Garry said...

RE: Synchronising forms

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

· Want To Get Started With Macros In Microsoft Access?
· MS Access and Database Normalisation
· Material covered on a Microsoft Access Course
· Take an Access Course to Learn About Relational Databases
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips