Drop Down List changed everything

[MucBob61]

Hello,

I was creating a basic database for a production floor. I set up everything
from the start to be just data key stroked in by a production manager.

Once I created all the queries, reports, etc I went back in to try and make
the data entry as quick and as easy as possible.

My first step was to add a table of Customer Names which was done. I tried
to then convert the original table (the main table) Customer name to a look-
up of that table to create a drop down.

I did this and everything seemed fine but now whenever I run my
queries/reports it pops up a new parameter to type in Customer Name, then the
pop up box I created.

I need to delete this parameter box in some way. Anybody have any ideas?

Thanks,

MUCBob

 

[Jeff Boyce]

It sounds like you've re-discovered another reason why the folks here are
generally down on the idea of using "lookup data types" in tables (you are
describing a table combobox, right?).

Most of the folks who lend a hand here don't use the lookup data type.

Instead, we use a form and a combobox.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MucBob61 via AccessMonster.com]

Thanks Jeff. I appreciate it. I am going to work on making the switch.

Bob