Listbox or Combo Box?

[Mike]

This is probably a simple problem, but I can't figure it out. I have query
linking two tables of data. Within the query I'm extracting data using two
fields "PN" and "Work Center". I'm using these two fields in a form, which
is where my problem is. The form will give me the correct PN associated
with the work center, but I would like to see all the PN's associated with a
Work Center. Should I use a listbox or a combobox or ? to extract this
information. If so, how?

 

[Albert D. Kallal]

Actually, you might find that suing a continues sub form also does the
trick!

The reason why I mention a continues sub form is that you obviously has a
standard one to many data relation here. So, for each Work Center, you need
to display a "list" of the matching PN numbers.

So, if you create a sub-form, then you don't need to write any code to
display that list.

In fact, you might try and let the wizard build the sub-form.

For some ideas, and few screen shots of listbox, and continues forms, take a
look at:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

 

[Mike Painter]

This is probably a simple problem, but I can't figure it out. I have query
linking two tables of data. Within the query I'm extracting data using two
fields "PN" and "Work Center". I'm using these two fields in a form, which
is where my problem is. The form will give me the correct PN associated
with the work center, but I would like to see all the PN's associated with a
Work Center. Should I use a listbox or a combobox or ? to extract this
information. If so, how?

Usually a list box would serve here. It is always "open" whereas a combobox
has to be opened to see things.
The combo allows finding an item by typing in more than one letter in the
description whereas the list just goes to the first letter.

The other post about using sub-forms is also something to be considered.

From what you describe I'd start with a listbox.