A
als
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
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