If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MSoffice Form Template Help
I am pretty new to Access. I am using MSAccess2007 and the MSOffice Template
for Managing orders from 2003. Here is my question and I hope someone can help me. I have changed some of the underlying tables headings to met my needs. Such as "Product" I changed to "Nomenclature". On the Add an Order Details Form there is a subform called "Order Details Subform". I changed the heading in this form to meet my needs, i.e. "Nomenclature". In the orginal template form the "Nomenclature box" is a dropdown list box and pulls list entries from the table. I changed this drop down list box to an unbound text box. I want to be able to enter nomenclature items in the unbound box and save this record as a OrderForm. Each time I place an order I want to use this form. I do not want to order items that are on a list in a table as I order many, many different items and I have no way of knowing from one day to the next what an item might be. Therefore I can not use a list of products to choose from. When I changed the dropdown list box to a unbound box, I enter the item that I want to order in the "Nomenclature unbound box". When I hit the enter button or tab button, each line below the first line in the subform automatically populates with the item that was entered into the first line box. If I change the Nomenclaure box from an unbound text box to a bound text box, I get an error msg, #Name?. What am I doing wrong. I want to be able to enter an item on each line and have the items saved to a table. Each main form should be a stand alone order form from one company with a number of different items that I am ordering from that company. I kept the integrity of the template the same as when it was downloaded. The only changes were Product name was changed to Nomenclature name. Once I get this ironed out I will need to make a few more changes such as calulations in the query. Can anyone please help me? |
Thread Tools | |
Display Modes | |
|
|