Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 15th, 2017, 08:57 AM
Registered User
Points: 25, Level: 1
Points: 25, Level: 1 Points: 25, Level: 1 Points: 25, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2017
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access - Subform Special Combo box

I am trying to create a combo box on a subform. I want the combo box to have a set list of options to choose from and and option to add a new option to the list. Once the added option is added to the list, I want to be able to use it in other forms that access this subform.

Also, upon editing anything in the subform I want the subform to automatically refresh and update the form it pulls information from.
  #2 (permalink)  
Old May 15th, 2017, 04:39 PM
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

You should be able to do what you stated within Access.
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh combo box on subform Tosame Access VBA 1 April 9th, 2010 08:25 AM
Access Data from a combo box darkhalf Access VBA 1 February 22nd, 2008 04:28 PM
Subform combo box 'reverse lookup?' russ2rsa Access 2 June 12th, 2006 08:26 AM
Subform combo box insanity Freddyfred Access VBA 5 June 9th, 2004 07:37 PM
Access Combo box with sql server jbritz Access 4 June 18th, 2003 11:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.