|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 2nd, 2010, 06:23 PM
posted to microsoft.public.access.forms
|
|||
|
|||
How To Access From VBA A Tables Row Lookup Row Source
Hello:
I created a table field with a Lookup Row Source Property Type = Value List and a hand-coded list of values. The user can right click this field in a form and add additional values to the hand-coded Row Source (i.e. Joe, Mary, John, and then they add Mark). How can I access the Row Source in VBA because I need to use it in a drop-down UNBOUND Combo Box. Is that possible? I searched everywhere including the Object Browser. -- Rich Locus Logicwurks, LLC 
|
|
#2
February 2nd, 2010, 06:40 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
How To Access From VBA A Tables Row Lookup Row Source
You should not be using table lookup fields:
http://www.mvps.org/access/lookupfields.htm -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Rich Locus" wrote in message ... Hello: I created a table field with a Lookup Row Source Property Type = Value List and a hand-coded list of values. The user can right click this field in a form and add additional values to the hand-coded Row Source (i.e. Joe, Mary, John, and then they add Mark). How can I access the Row Source in VBA because I need to use it in a drop-down UNBOUND Combo Box. Is that possible? I searched everywhere including the Object Browser. -- Rich Locus Logicwurks, LLC
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
