How to create a combo box in a table

[Gene G]

OK I will try and make this as detailed as I can

I have a form in that form there is a sub form in a tab, that sub form would
contain a data sheet that has a drop down Box , that drop down box selects a
given product and up dates the price in one of the colums in the data sheet,
by then entering your quantity it would then give you a total and that
record apon hitting a command button would then be recorded.

Here is my problem I am able to create a form based on a table, placing a
combo box that will up date the text boxes with the selected info, but Im not
able to get this proces into a data sheet to appear in the sub form.

Actually if you look at Northwinds that comes with access and I have for
countless hours and still no success, the suborder for order details form
essentially that is what im trying to do

 

[Arvin Meyer [MVP]]

STOP! Do not work in tables for data entry or editing. Always use forms. You
can easily create datasheet view forms which look like table datasheets, but
will allow validation and VBA code or macros. The Northwind sample database
is an example of how to use some Access features, not good database design.

For a list of reasons why you should use a query to do lookups instead of a
field, have a look at:

http://www.mvps.org/access/tencommandments.htm
and:
http://www.mvps.org/access/lookupfields.htm

 

[John W. Vinson]

Here is my problem I am able to create a form based on a table, placing a
combo box that will up date the text boxes with the selected info, but Im not
able to get this proces into a data sheet to appear in the sub form.

So? Don't use a Datasheet then; use a Continuous Form.

If you'll post the nature of the problems you're having creating a combo box
on the form we'll be glad to help. It's just NOT necessary to put a combo box
into a table to accomplish this.

 

[Chris D]

I have created this function several times. It goes like this:

The table the datasheet is showing should have an ID for the product and a
reference to the product list by ID for the cost of the ID'd product.


Add a combobox that looks up its rows in the product list with a bound on
the ID for that product.
Set the datasorce to the ID in the data sheet.
Once the user chooses the product by name from the combobox the ID will be
changd in the datasheet table. Since the ID in the Table determines the price
to display you will see the price data change in the datasheet due to the
reference.

*Note that the combobox looks like a cell in the datasheet that is dropdown.