generating a field by selection of another

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

Guest

Hi,

I am trying to set up a column which is generated by selecting from a drop
down list in another. E.g. When selected in a a table field Country
"Netherlands" it show sautomatically "EUR" in field 'Currency"next to it.
Field "Country" detemines basically what is shown in field 'Currency". What
is the easiest way to do this?
 
In a query or in a form?

You can use Dlookup to look for the value

In a form, write in the control source of the Currency field
=Dlookup("Currency","TableName","Country = '" & [CountryFieldNameInTheForm]
& "'")
 
Alex,

The Row Source of the Combobox for Country is based on a table where all
the countries are listed, right? You will need to have a field in this
table also for Currency... do you have that now? If so, you can simply
include this Countries table in the query that your form is based on, so
the Currency can be included directly in the query, and hence on the
form. This approach, as well as a couple of other ways of doing it, are
explained in this article...
http://accesstips.datamanagementsolutions.biz/lookup.htm
 
Back
Top