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

  • Thread starter Thread starter mike
  • Start date Start date
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?
 
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?
Click to expand...

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.
 
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.
 
Back
Top