Combo Box Form Query - Erases Existing Fields When Formatted

I have a .mdb table (TreeDatabase2008_Points_sp) Linked in to my
access database.
From that linked table I have created a form (with the form wizard)
that will be used for adding and editing values in the table.
By the way, this table has approximately 15 fields and 18000 records
in each field and i am using Access 2007 on a windows xp machine.
For the ease of add/ editing the data, I have created a combo box with
the following query for my first field:

SELECT DISTINCT TreeDatabase2008_Points_sp.Street
FROM TreeDatabase2008_Points_sp
ORDER BY TreeDatabase2008_Points_sp.Street;

This query allows all of the existing records to be in alphabetical
order and show no duplications.
The problem is: Once I run the query, all of the Existing data (18000
records) that was in the field in the form is deleted. It still
appears in the table but it is gone from the form.

I am a new user to Access and I'm sure this is probably an elementary
question but if anyone could help I would really appreciate it.
Thanks,
alison

In design view click on the combobox, doubleclick and select properties.
Select the field name for the Control Source.

--
KARL DEWEY
Build a little - Test a little


"als" wrote:

I have a .mdb table (TreeDatabase2008_Points_sp) Linked in to my
access database.
From that linked table I have created a form (with the form wizard)
that will be used for adding and editing values in the table.
By the way, this table has approximately 15 fields and 18000 records
in each field and i am using Access 2007 on a windows xp machine.
For the ease of add/ editing the data, I have created a combo box with
the following query for my first field:

SELECT DISTINCT TreeDatabase2008_Points_sp.Street
FROM TreeDatabase2008_Points_sp
ORDER BY TreeDatabase2008_Points_sp.Street;

This query allows all of the existing records to be in alphabetical
order and show no duplications.
The problem is: Once I run the query, all of the Existing data (18000
records) that was in the field in the form is deleted. It still
appears in the table but it is gone from the form.

I am a new user to Access and I'm sure this is probably an elementary
question but if anyone could help I would really appreciate it.
Thanks,
alison

On Aug 27, 6:52 pm, KARL DEWEY
wrote:
In design view click on the combobox, doubleclick and select properties.
Select the field name for the Control Source.

--
KARL DEWEY
Build a little - Test a little



Thank you for your comment.
But I already have the field name selected for the Control Source.
Any other suggestions?

Ok, these may seem like silly questions but I can not see your database.
What do you have for the following --
Row Source
Control Source
Column Count
Column Widths

--
KARL DEWEY
Build a little - Test a little


"als" wrote:

On Aug 27, 6:52 pm, KARL DEWEY
wrote:
In design view click on the combobox, doubleclick and select properties.
Select the field name for the Control Source.

--
KARL DEWEY
Build a little - Test a little



Thank you for your comment.
But I already have the field name selected for the Control Source.
Any other suggestions?