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