Lookup values on a form, trivial question?!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • Not losing focus on current textbox when pressing a different button
    ... Microsoft Dynamics does and use separate textbox and lookup button. ... What I have is, simply, is a C# winform, a textbox and a pushbutton. ... on the validating event of the textbox I check my customer ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Lookup values on a form, trivial question?!
    ... Field B-D should (after input value is entered in "textbox A") display ... information about the customer in different textboxes (such as "customer ... In excel I'd just use a simple Lookup ...
    (microsoft.public.access.forms)
  • Re: Similar tables with different pricing methods for same item
    ... custom-configures a main item based upon customer choices (think of ordering ... But in my system, discounts are handled separately and in a Discounts table, ... > The usual method, is a lookup table of unit of sale, i.e. ... > CASH price etc. ...
    (microsoft.public.vb.database)
  • Re: Database structure
    ... When you made your Mfr table, did you then put a lookup in the products ... You want that specific to the customer ... > Then I added a table for manufacturer and linked it to the products so ...
    (microsoft.public.access.gettingstarted)
  • Re: vlookup change column index position - without changing formulae
    ... Use a cell value. ... Then all you do is plug the column id in A10. ... > I gain a customer B in August so in my lookup cust C has moved to col 3, ...
    (microsoft.public.excel.worksheet.functions)