EMERGENCY!!!!!!!!!!!!

M

mike

What is the procedure for editing a data base? I have a
drop down box in one of my fields that has text that i
want to delete and insert new text. How is this done?
 
J

John Vinson

What is the procedure for editing a data base? I have a
drop down box in one of my fields that has text that i
want to delete and insert new text. How is this done?

Screaming Subject lines will not help you much. It's much more polite
to say something like "How can I Edit values in a drop down box".

There are several ways to do this. Typically the Combo Box ("drop
down") will be based on a Query on a table; you can open that table
(or better, a form based on that table) to edit its contents, and the
combo will thereafter reflect the edited data.

Or, you can use VBA code in the Combo's Not In List event to update
the table. The details will differ somewhat depending on how your
table is structured. See http://www.mvps.org/access and search for
"Not In List" for sample code.
 
D

Debra

Or... If open in design view, select the field box, right
click and select "properties", click on the "data" tab and
edit your text in the "Row Source" line. Don't forget,
each word is surrounding by quotation marks and separate
each word with a semicolon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top