Pulling List Items from front end database

[googalabosh]

OK. So, before I begin I want to admit that the way this is set up isn't ideal but unfortinately it is the way it has to be. Moving on...

My database is set up as a front end (this includes all the forms, queries, and reports which is accessed by the end user) and a back end (this includes all the tables which are linked to the front end).

Currently, to edit a drop down list, I have to access the back end to edit the list items. I want the dropdown lists to be editable from the front end. My goal is to keep the end user from having to access the back end (where all the valuable data is) just to edit a drop down list.

Is this possible?



TIA

-Justin

[ranman256]

If you mean edit the values in the table, yes. It can be done at FE. Just open the table and add the data.
I have a tiny button next to the list/combo. it opens the table to add values.
but you must click the REFRESH ALL button (on toolbar) when you finish to update the form list with new values entered.

(you cannot edit table DESIGN in the front end)

[googalabosh]

That actually worked. Odd thing, when I tried that before it wasn't working. Oh well. One problem solved! Thanks for the help.