Data Entry in Access

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

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.
 
Danielle said:
I want to enter a Suite # in my Form and upon hitting the Enter key, I
Click to expand...
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.
 
Back
Top