Re: Help with lookup drop down.
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 14 Jan 2007 21:40:51 -0500
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
.
- Prev by Date: Re: table relationships
- Next by Date: Find and Replace in the Whole Base
- Previous by thread: Re: Integrating MS Access database with a point of sales software
- Next by thread: Re: Help with lookup drop down.
- Index(es):