UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Combo List Box And Not In List, Office 2013    
 
   
wornout
post Feb 22 2017, 11:10 PM
Post#1



Posts: 972
Joined: 17-November 13
From: Orewa New Zealand


I have a combo box on a user form that Adds Items at form Activate the code is as below
I wonder if it is possible to, if not in list another form pops up that only admin user can use where she could add to the list but I don't want her to have direct access to the code
I have 3 comboboxs I would like to do this for

CODE
With ComboBox1
.AddItem "Investigation"
  .AddItem "Planning"
.AddItem "Eng"
.AddItem "Subd"
.AddItem "Redef"
.AddItem "Topo"
.AddItem "SetOut"
.AddItem "HRTB"
.AddItem "Unit Title"
.AddItem "LT"
.AddItem "As Built"
.AddItem "Easement/Covenant"
End With
Go to the top of the page
 
ADezii
post Feb 23 2017, 11:00 AM
Post#2



Posts: 1,857
Joined: 4-February 07
From: USA, Florida, Delray Beach


How about eliminating the Code altogether?
  1. Create a Table named tblEntries with a single Field named [Entry] as follows:
    Entry
    Eng
    Subd
    Redef
    Topo
    SetOut
    HRTB
    Unit Title
    LT
    As Built
    Easement/Covenant
  2. Hide this Table.
  3. Create a Query named qryEntries which lists the entries for the Combo Box in alpha order:
    Entry
    As Built
    Easement/Covenant
    Eng
    HRTB
    LT
    Redef
    SetOut
    Subd
    Topo
    Unit Title
  4. Set the Row Source of your Combo Box to this Query.
  5. Allow an Administrator(s) to Add, Edit, or Delete Records in tblEntries, either via a Form or SQL Statement.
  6. Requery the Combo Box.
  7. No Code modification required with this approach.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 05:19 PM