Display all records, each in a form text box

  • Thread starter Thread starter Patti
  • Start date Start date
P

Patti

I have a "Products" table that contains a product number in one field, along
with a product description in another field. Is it possible to create a
form based on the table that will show each of the product descriptions?
There are about 70 different products.

I want to model the form after a paper order form that the customer has.
What I envision is, the data entry person will have the paper order form,
and will be able to tab from one item to the next, entering the quantity.
While it is possible that some items will not be ordered, the majority will
have a quantity listed for each product. If I can help it, I really do not
want a combo box.

I hope this makes sense...I did try a google search, but couldn't find a
solution.

Thanks in advance,

Patti
 
Create a form to mimic an order form... definitely.
Create a report to mimic the order form... definitely.

For the count and description of the form I would put it
in a subform, datasheet view.

I have to admit the easiest way to pull the information is
through a combo box. I know... the dreaded words. I use
to not like the combo boxes and then I started using them
more and found they can do a whole lot more than
previously expected. Looking at it from a data entry
perspective, it auto-populates when you are typing. If
the number the person is trying to type in does not come
up, it's a given that it is not in the system.
In the properties of the combo box:
Format tab
Column count: (probably 2 if wanting to show product
number and description)
Column width: (depending on how long the longest desc.
is) if using 2, then width would be 1";4"

Data tab
Row Source Type: Table/Query
Row Source: [your table]
Bound Column: (I normally use the ID column in the table,
usually 1)

Good Luck.... debbie =}
 
Back
Top