Access 2003 simple question

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

Guest

I am just getting started with Access and have a simple question. I have a
basic table with part information in it. I would like to have a small window
open up where I can pick one of several fields in which I can specify a look
up value then hit a key and have that particular record with all the other
fields show up. Anyone care to help a rookie get started?
 
It sounds like you have your table laid out as a spreadsheet. Access is a
relational database and it gives you better results if you use it like it is
intended.

Post your table structure field names and DataType. Also post sample data
and what you are expecting the data display to look like.
 
I am just getting started with Access and have a simple question. I have a
basic table with part information in it. I would like to have a small window
open up where I can pick one of several fields in which I can specify a look
up value then hit a key and have that particular record with all the other
fields show up. Anyone care to help a rookie get started?
Click to expand...

Don't use table datasheets, and ESPECIALLY don't use Lookup Fields. See

http://www.mvps.org/access/lookupfields.htm

for a critique of what many of us consider a misfeature of Access!

Instead, use a Form based on your table. You can use the Combo Box tool from
the toolbox to put a combo on the form to select a value (a "lookup" if you
will, but in its proper place on a form rather than in a table) to navigate
the form to that record.

John W. Vinson [MVP]
 
Back
Top