access and windows xp sp2

[Guest]

I have writing a couple time to this board with the following problem. I have
a small data base of 222 names. I had a form and everything was going good. I
went into the table and tried to put a drop down list. I succeed at this but
now I dont see my names in the form. They are still in the data base because
I still see them in the table. I have gone into the properties of the form
and have tried to find the problem but without any luck. If I had someone who
answer questions on this board email adress I would send him the database to
see if someone could find the trouble. I have gone into the code VB but I can
not find anything.

 

[MacDermott]

Did you put the drop list in the table, or on the form?

Drop lists can be wonderful on forms, but they are seldom a good idea in the
tables themselves.

Could you post the SQL for the query in the drop-down list's rowsource?

- Turtle

 

[Guest]

If I understand you question, I done it this way. I went into the table, on
the field that have the "town", I put a drop down list with a value list and
proceed to put all the "town" in that drop list in the following manner.
("St-Louis";"Richibucto" etc)
Hope this is clear. Thanks

 

[MacDermott]

On your form, do you have a drop down list, or a simple textbox for your
City field?

 

[Guest]

I have a drop down list.

On your form, do you have a drop down list, or a simple textbox for your
City field?

 

[MacDermott]

Open your form in design view.
Display the property sheet for the drop down list.
Look in the RowSource property.
Is your list of cities there?

 

[Guest]

Yes the list of city are there. The list works fine it is all the records
that were already put in that I dont see. This as happen when I was trying to
put the drop down list.
Thanks

 

[MacDermott]

Look at the property sheet for your form.
Is DataEntry set to Yes?
It should be set to No.

 

[Guest]

That did the gob. I thank you very much.

Look at the property sheet for your form.
Is DataEntry set to Yes?
It should be set to No.

 

[MacDermott]

Please note that this solution had nothing whatsoever to do with the
drop-downs.