dropdown from table or query

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

Guest

Hi

I have a database table as follows:

Make Model Cost
Fiat Brava €24000
Fiat Bravo €22500
Fiat Punto €18750

Make can be a text field or I could make it a dropdown field
What I would like in a Table or a Query is that when I type Fiat or even
choose Fiat from the lookup I would like the Model field to display the
different options of the Model automatically so that I can pick the model I
require. Is this possible. At the moment all my makes are coming up -
Ford types, Mitsubishi types etc..

Any help would be greatly appreciated - even if it's only possible on a form
that would be fine. I just don't know where to start.

Many thanks
 
Write a query with event On Lost Focus behind the Make dropdown field in a
form to restrict the display.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
Sorry but I use Access but don't know how to write a query with event on lost
focus
I would not know anything about SQL VBA etc I would fairly advanced on the
application side thought. Is this difficult to do?

Many thanks
 
Back
Top