Re: Help with lookup drop down.

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



See this article:
http://www.mvps.org/access/forms/frm0028.htm

You can do it in a form, but not in a table.
--

Ken Snell
<MS ACCESS MVP>


"Scott" <Scott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D6BEBC5F-681F-4B4C-8F9C-9FFC14931E35@xxxxxxxxxxxxxxxx
I am not sure if it is possible, but I would like to create a data*** and
form where I can have a drop down (lookup) for a field and then have the
next
field have a drop down (lookup) based on the selection of the first field.
For Example:

If in field 1 I have a list of manufacturing lines Modules 1, 2, 3, 4 then
on field 2 I would like to have a list of machine numbers based on the
module
selected in the first field. So, if Module 2 is selected then field 2's
drop
list would list the machine numbers for Module 2. Can this be done? Is
there
a way to create a condition for calling up a table or data***?

Thanks,

Scott


.


Quantcast