am new to access and I am trying t

[3239]

I am new to access and I am trying to break an access database template down and use the tables, forms, and queries for my own use. There is a Form called,Add an Order and Details that has a subform called Order Details that I am having trouble with.The trouble I am running into is when I try to Set the "Row Source" property for the ProductID combo box on the form , I see SELECT DISTINCTROW Products.* FROM Products ORDER BY Products.ProductName;in the property box . I know that this has to be the reason why the data that I want to be visible in the ProductID combo box is not showing up. I don't know what SELECT DISTINCTROW Products.* FROM Products ORDER BY Products.ProductName; mean or how to use it. Please Help.

Tony 3239

 

[dzepeda]

That's mean "Select all fields of Products table order by ProductName"(also all records). The reason why you can't see your data is not the SQL sentence(unless the table Products is empty), the reason is the property Column Width, this say to access what field show(width of each column of the query)

If you are using the access template, all tables may be empty. Enter some data before try to edit the database.