Maximum Records

[livvie]

I have a combo box on my form and I need it to show all distinct part numbers as this then provides the record source for a form. The problem is that I can only get it to display 10000. if I then go to the query and change it I can see all recs but when I run it again it is back to 10000 again. How do I get the query to show all recs all the time.

 

[livvie]

Just found out very simple really.
Tools Options Advances Max Records

 

[sthapa]

is this the same route for Access 2000 ?

 

[livvie]

is this the same route for Access 2000 ?

When I converted back to Access 2K I changed the amx records on the query and this setting was saved at this point so the same problem doesn't occur.