The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Combo box on sub form

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Combo box on sub form

Resolved · High Priority · Version 2003

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

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.

For upcoming training course dates see: Pricing & availability

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

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

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

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 articles

· How To Use Referential Integrity In Microsoft Access
· How To Use Calculation Fields In Microsoft Access
· Discover The Top Ten Changes In Access 2010
· Growing A Customer Base For A New Business - With The Help Of Access
· Microsoft Access Training Opens Doors

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

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

How do I split a task?