Lookup values on a form, trivial question?!

[Mikael Lindqvist]

Hi everyone,

This is really silly but I have searched everywhere (starting with my "Form
and report design for Access 2007" book) for an explanation on how I make a
form with:

Field A (text box) is INPUT value (customer number), and
Field B-D should (after input value is entered in "textbox A") display more
information about the customer in different textboxes (such as "customer
name, phone number etc")-

(This is just an example, the "customer-information" could be in one or
several different - relational - tables, if that makes a difference...).

My question is: How can do this? In excel I'd just use a simple Lookup
formula, but the whole point with a proper database is that I use relations
instead of endless "lookup formulas".. but so far I have failed to get this
working.

Any help much appreciated!

(As soon as I get this going I'll add split menu with more information, such
as last 10 customer transactions etc).

Kindly,
Mikael
Sweden

 

[Arvin Meyer [MVP]]

There are multiple ways to do this. You can use a textbox and listbox to
choose data to be shown in a form:

http://www.datastrat.com/Download/ExpandingSearch2K.zip

or you can use a multicolumn combobox and set the text boxes to read the
additional columns:

=Mycombo.Column(2)

etc. Column 2 is actually the third column because the column index is zero
(0) based.