Combo box on sub form

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

Resolved · High Priority · Version 2003

9 posts

ReplyWed 4 Nov 2009, 09:25Delegate Heather said...

Heather has attended:
Access Intermediate course
Access Advanced course
Excel Advanced course

Combo box on sub form

I have created a sub-form with a combo box of hobbies and interests. However when I select a hobby from the list and then move to the next record, when I go back to the original record the hobby I selected is no longer showing although when I look at the Table related to the form, the data is there.

Any help with this will be very much appreciated.

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		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

748 posts

ReplyWed 4 Nov 2009, 13:44Trainer Stephen said...

RE: Combo box on sub form

Hi Heather

Thanks for your question

Could you clarify the following please

1. Is the Combo Box on the main form or the subform?
2. When you move records are you moving inj the sub form or the main form?

Thanks

Stephen

9 posts

ReplyMon 9 Nov 2009, 08:00Delegate Heather said...

RE: Combo box on sub form

Hi Stephen, Apologies for the delay in coming back to you - went home on Weds morning with some horrible flu like bug and have just come back to work today.

To answer your question, the combo box is on the sub form but when I move between records I am doing so on the main form. Really puzzled by this one as I have used the wizard to set up a couple of sub-forms before this one, and all has been fine.

Thanks for all your help with this.

Regards
Heather

748 posts

ReplySun 22 Nov 2009, 11:07Trainer Stephen said...

RE: Combo box on sub form

Hi Heather

Thanks for the information, ans please let me apologise for the long delay in getting back to you.

I think the problem may be that the wizard building the combo boxes may not be up to the job in this case. To help I need to see the SQL that controils them.

If you open the form in design view and open the properties window for one of the combo boxes. You can then copy and paste the SQL statement in the Row Source Property into a text file.

If you email that to me at SW

I will try to provide assistance

Regards

Stephen

If you

9 posts

ReplyMon 23 Nov 2009, 16:30Delegate Heather said...

RE: Combo box on sub form

Hi Stephen

I tinkered around with the properties in between my last email to you and your reply and somehow the the problem seems to have righted itself but not sure which of my changes did the trick.

Thanks for your help and will send you the code if it happens again.

Regards
Heather

· Access 2007 Is All About Systems!!
· The Three Classes of Databases
· Why a Microsoft Access Course Could Change the Way You Do Business
· How much time could you save with Access?
· Reasons to Consider Microsoft Access Training

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

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