Dlookup (then) Dlookup Next Record, How?

[musicmaker]

I have Access 2000.

The table, in form view is where I am entering a large number of addresses. My first entry field is [ZIP CODE]. I want to be able to view all other enteries within this table/form that has the same Zip Code, when I enter a zip code into a new record. I want to see [Name] [Address] and [CityStateZip]of every one that has the same [Zip Code].

ACCESS will not allow me to use the lookup wizard within the same table otherwise I would solve the problem that way.

Any help would be greatly appreciated. Thank you in advance!

 

[ntp]

Would it not be easier to create a query with the zipcode as the criteria then use a subform or a listbox to display the information from the query?

You don't know how many records will be returned so doing something like a dlookup then another, could lead to a pretty long loop in our code.

ntp