Data Entry in Access

[Guest]

I want to enter a Suite # in my Form and upon hitting the Enter key, I want all relevant info pertaining to that Suite # to automatically appear in their correct box. This will help save time when entering a new record for the same suite #'s over and over again. I can then go on to the other areas of my form and fill them out manually.

 

[Mike Painter]

I want to enter a Suite # in my Form and upon hitting the Enter key, I

want all relevant info pertaining to that Suite # to automatically appear in
their correct box. This will help save time when entering a new record for
the same suite #'s over and over again. I can then go on to the other areas
of my form and fill them out manually.

That's what Access does and quite nicely.

It is done by using a query to relate your Suite table with the other tables
you may need.

The rather large Northwind database, along with the massive help file gives
many examples of this.