Value list updates not appearing in form

I have a table with several fields who's display control is combo-box, source 
is value list, and multiple values are allowed.
In one of the fields, when I add a new option to the value list, it 
automatically appears in the drop-down list in the form. Not so for the other 
field! When I go back and add more values to the list, they do not appear in 
the combo box drop-down list in the form. I've been working around it by 
manually adding the new options to the value list in the form's properties.
Why does it work for one field and not the other? I can't see anywhere where 
the field properties are different.
The database is split, the form is on the front end, if this makes any 
difference.
Thanks,
Jey
0
Utf
6/2/2010 7:36:05 PM
access.forms 6864 articles. 2 followers. Follow

1 Replies
1169 Views

Similar Articles

[PageSpeed] 50

Ah ha, I figured it out, sorry for the premature question. I'll answer the 
question myself, just in case anyone else runs into the same problem.

It's the 'inherit value list' property (in the form, not the table)... it 
must be set to 'yes'!


0
Utf
6/2/2010 8:52:31 PM
Reply:

Similar Artilces:

Task list colors
I know that the task's in the task list in outlook turn red when overdue, but is there a way to color code the tasks in the task list similar to the way the can be color coded in teh calender? I.E. I'd like to make my personal tasks green and my work related tasks blue then they turn red wen overdue. Thanks in advance Russ Keller Look into Automatic Formatting rules...you can find the AF button on the Customize Current View dialog. -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve th...

possible to update resource without rebuild?
I need to change the logo we use on a 3 year old release. It is a real pain setting up for the build and getting the old source code. Then I have to turn around and do the same thing for the product update that came out later that year. Is the a way to run some edit utility that can replace a resource in an exe. The logo is saved as a bitmap file in the resource. I would like to update the old exe without going through the whole headache. "River Ross" <river.ross@sbcglobal.net> wrote in message news:YWOSd.40035$wi2.7686@newssvr11.news.prodigy.com... > I need to ...

Updating and inserting an existing xml document
This is a multi-part message in MIME format. ------=_NextPart_000_00B1_01C49404.1F4D82D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am new to this xml. How can I update and insert some values in = existing xml document. which parser i can use for it in dot net. Whether dot net = XmlTextWriter I can user for this or there is any other way is there ?? Thanks and Regards, Pradeep. ------=_NextPart_000_00B1_01C49404.1F4D82D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ...

Auto Number for Form
Is there a way to auto number printed forms in Excel 2007? Example: mechanic worksheet that is printed in batches of 100. I need consecutive numbers on each copy. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- David Biddulph "DHull" <DHull@discussions.microsoft.com> wrote in message news:65454920-BAEE-4B51-B66D-A4E04B097E7D@microsoft.com... > Is there a way to auto number printed forms in Excel 2007? Example: > mechanic > worksheet that is printed in batches of 100. I need consecutive numbers > on > each copy. Hi , See ...

Microsoft Dynamics GP Report: Position Codes List
Accounting says HR cannot change the use of this field. The field should be used for position code Like "senior retail" . It was set up to track our codes for payroll percentages. Accounting says it drives g/l postings? The field links to over 80% of the HR package..hence the reason we are looking at a $200,000 package. Has anyone encounter this before? Ed Accounting is correct. Payroll tracks each of the position/manager/employees and has intrinsic code behind it that is used for Tax and posting reporting. Before you spend that $200,000 though...almost every module in G...

Problems expanding distribution lists
Hello! We have some problems expanding distribution lists. Background: We are running trhee MSXS2k, placed in two routing groups at two locations, connected by WAN. In each location there are two DCs and two GCs. We are using global security groups for mail distribution - we have only one domain, so... Here is what it's all about: From location A, every user working with this MSXS can send mail to a DL and the message is delivered. From location B, users can see the DLs and send mails to them, but they do not reach anyone. Reason for that seems to be, that the categorizer on MSXS in...

Drop Down List Going up off screen
Is there a way to force the drop down lists to only open downwards? I have my drop down boxes at the top of the spreadsheet and for some reason, it is opening up and I am unable to see half of the list as it is off of the screen. Thanks! -- Hulk ------------------------------------------------------------------------ Hulk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14947 View this thread: http://www.excelforum.com/showthread.php?threadid=556040 ...

Calculated fields on a form
Hello I have a series of related tables (and the relationships work fine on the form) and I am trying to do a calculated field on a form : I have added a textbox and built the formula =[tblBrochures]![Quanity]-[tblOrders]![OrderAmt] both the variables are "single" But I get an error #Name? returned. ideally i would like to have the Quantity assigned the value of [tblBrochures]![Quanity]-[tblOrders]![OrderAmt]. Can someone please help? Are both of those fields, [Quantity] & [OrderAmt], bound to your form? If so, you can just omit the table names altogether. ...

IE closes when I want to update flash, etc. malicious content mess
internet explorer 8 closes saying malicious content message, displayed constantly occuring with simplest of updates, and other day to day destinations like myspace links/pages. rock roll <rockroll@discussions.microsoft.com> wrote: > internet explorer 8 closes saying malicious content message, displayed > constantly occuring with simplest of updates, and other day to day > destinations like myspace links/pages. Time to scan your machine for viruses or other malware... ...

Microsoft Dynamics CRM should let me change default value of Filte
Microsoft Dynamics CRM should let me change default value of 'Filter on' pick list include into Activities list under Contact and Account. The default is set to 'Next 30 days'. We should be able to change this default to other value like ALL, because in some business they visit their clients only once a year. -- Sylvain ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this lin...

Cotrol list
Hi, Can anybody suggest me with following. I want to define in the Control List subitem as a check box. How can I do it and if an example is possible will be fine. Thanks in advance EK See if www.codeproject.com/listctrl/xlistctrl.asp helps. "EK" <evgenik@hotmail.com> wrote in message news:eVd2EuM4DHA.2332@TK2MSFTNGP10.phx.gbl... > Hi, > > Can anybody suggest me with following. > I want to define in the Control List subitem as a check box. How can I do it > and if an example is possible will be fine. > Thanks in advance > EK > > ...

Account not showing in Favorite list
Hi, I recently created an account which is not showing in my favorite list even though I checked "Favorite account" and unchecked "This Account Closed" options. ...

Office 2004 won't update
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Trying to install "Office 2004 11.5.0 Update" but get the following error: "The installer could not locate the correct version of the software required to install this update. See the Read Me file included with this installer to determine if your software meets the requirements for this update." The Read Me don't say boo... Searched around for why, but didn't find anything... "bubba@officeformac.com" wrote: > rying to install "Office 2004 11.5.0 Update" but get the ...

How to get frame color of a edit box, list box, etc. on XP?
Is there an API that I could use to find the value of the 'blue-ish' color used by XP to draw a rectangle around edit box, list box, etc.? I'm looking for something like GetSysColor() (which I don't think will be of any help in this case, will it?). Thanks, Bob It is probably one of the ::GetSysColor options. joe On Mon, 27 Nov 2006 09:35:09 -0500, "bob" <bob@nospam.com> wrote: >Is there an API that I could use to find the value of the 'blue-ish' color >used by XP to draw a rectangle around edit box, list box, etc.? I'm looking...

Mac Stuff CDs, A to Z, updated 2007/September/20, and Win & Mac programs, 'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform', 'MultiFormat', 'MULTIOS', 'HYBRID'
Mac Stuff CDs, A to Z, updated 2007/September/20, and Win & Mac programs, 'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform', 'MultiFormat', 'MULTIOS', 'HYBRID' please send e-mail loa210@mail.gr , loa210@mailbox.gr , -------------------------------------------------------- 08/22/2007 Mac OS X Tiger 10.4.10 X86 08/14/2007 Adobe CS3 Master Collection MAC OSX UB D1 .DVD 08/09/2007 Digidesign Pro Tools V7.3 LE MAC OSX 05/11/2007 Altiverb 5.1 .MAC. .PPC. OSX 04/26/2007 VTC Macromedia D...

sum two money value
Why when I try to calculate sum of two money value in JavaScript I get sum of strings: crmForm.new_totalbeforetax.value=crmForm.totalamountlessfreight.value+crmForm.freightamount.value; -- Alex okay, I need to use DataValue instead of value -- Alex "Alex" wrote: > Why when I try to calculate sum of two money value in JavaScript I get sum of > strings: > > crmForm.new_totalbeforetax.value=crmForm.totalamountlessfreight.value+crmForm.freightamount.value; > > -- > Alex ...

Filtering data based on historical values
Hello everyone, I am trying to sort a list of temperatures to analyze a chillers operation. The chiller turns on when the outside air temperature is 80, and turns off when the outside air temperature is 70. I am trying to find the time when the chiller is on (temperature was above 80 and didn't drop below 70) and the temperature is between 70 and 75. All I need is excel to display a 1 if it is on (and between 70-75) or 0 if off, because every 1 is a unit of time. All the sorts I have tried are unable to look back and see if it was turned on, because it may have been above 80 t...

List Box format Question
Is it possible to code a list box if 7th Column shows "e" then that line turns yellow?? Thanks for any help...............Bob [lstModify].[column](6)="e" then color Yellow Not with versions of Access earlier than A2007. Listboxes have only a single set of properties but I think you can alternate row colors with A2007. I don't think you can highlight specific rows, you'd need to check. "Bob V" <rjvance@ihug.co.nz> wrote in message news:uvkUWF1bIHA.4040@TK2MSFTNGP05.phx.gbl... > Is it possible to code a list box if 7th Column shows "...

Update failed to install
The following update message keeps coming up everytime i try to install this update Windows XP Microsoft .NET Framework 1.1 Service Pack 1 Security Update for Windows 2000, Windows XP, Windows Vista, Windows Server 2008, Windows 7, and Windows Server 2008 R2 (KB953297) Wednesday, October 21, 2009 Automatic Updates I need some assistance on how to insatll or delete it, it tries to install everytime i clsed down the computer. Thanks I have a similar problem; Microsoft .NET Framework 1.1 Service Pack 1 Security Update for Windows 2000, Windows XP, Windows Vista, Windows ...

Outlook 2007 Task Form Insert Ribbon (Attach Group)
Does anybody know what happened to the Insert Tab on Task Forms in Outlook 2007. Even some Microsoft training materials show an Insert Tab on the form for new Tasks. However, I can't find any way to make it appear, though it does show up on new Appointment forms. Has somethiing changed perhaps? Thanks for any insight anyone has. Bill I see it here as the 2nd tab on an open task. There is no Attach group, = though. The group with attachment commands is called Include. = =20 --=20 Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turt...

multiple Global Address Lists Exchange 2003
I have an environment with 2003 AD on 2 forests. One forest is housing user accounts and another is housing Exchange mailboxes with trusts between user and email domains. The structure is for multiple virtual companies so I need to hide all but the required GAL based on a group. As each mail enabled user has an account in both domains one for the user account and one as a mailbox resource, which user object needs to not have read access to a GAL to prevent viewing. The user on the exchange forest which owns the mailbox being used, or the user on the user forest that will actually be log...

Can I increase the view of a drop down list beyond 8 in Excel?
I created a drop down list from a group of more than 8 items (12 items). When the drop down list arrow is clicked, Excel shows the first eight than has the block on the right hand side to scroll down the list. I would like to see every item in the group at the same time. Is there a way to make my view longer to include all 12 items? Not if you used data|validation. dustinhess@jore wrote: > > I created a drop down list from a group of more than 8 items (12 items). > When the drop down list arrow is clicked, Excel shows the first eight than > has the block on the...

Locating Value Pack Add In on the web?
I have Office X for Mac installed, and am attempting to run a = spreadsheet=20 which needs the Analysis Tool Pack. I cannot locate it under Tools->Add = Ins, and also cannot locate the value pack installer on my disk. =20 Unfortunately, I am away from home, and do not have access to my=20 installation disk. Is there any place I can download the value pack = installer? =20 Its listed as FREE, so I would assume it would be easy to find, but to = no avail=20 so far. I'm not sure where "its (sic) listed as FREE", since you can only get it by buying Office (and IIRC, MS doesn&...

Sum large recordsets in a form..?
Hi all, I have a recordset that's 15 000 records in a form. The reason that I want so many records is beacase I want to use filters. This works fine. But if I try to summarize 15 000 numeric values it takes very long time (1 minute). I have tried: Me.ControlSource = sum([Value1]) Is there a better and faster way? One idea is to generate SQL-code from the filters. Kent J. On Mon, 24 Sep 2007 20:22:22 GMT, Kent J <kent.johnson@telia.com> wrote: >Hi all, > >I have a recordset that's 15 000 records in a form. >The reason that I want so many records is beacase I want...

Linking Multiple Queries and a SharePoint List
Hi, I have an Access 2007 Database (MyDB) which connects to an enterprise database (EnDB) using an ODBC connection. MyDB extracts a list of servers from the EnDB that have an error status, and appends (no duplicates) any records found into MyDB. All works well. I then have another query that cross-checks MyDB against the EnDB for any servers listed in MyDB where the error no longer exists in the EnDB, and if any are found it flags a feild in my local databse. I use two queries to acheive this - 1) Find unmatched Query, 2) Update Query (using the data produced in the Fi...