access and windows xp sp2

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
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?
 
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
 
Look at the property sheet for your form.
Is DataEntry set to Yes?
It should be set to No.
 
Back
Top