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
|
|||
|
|||
Re Combo Box
Im trying to put a combo box on one of the fields (PRODUCT) in the subform of
the main form. The form looks exactly like the ORDERS form in the Northwind Database, except that mine doesn’t have the last two columns and in the main form there are only two fields(SaleNumber[Auto] and Date) and there is a one to many relationship between the main form and subform. The problem is that everytime I try to place the combo box on the PRODUCT field, it is automatically creating another column next to the last column (Quantity) and places itself there. What could be the problem? |
#2
|
|||
|
|||
forms don't have fields, they have controls. if i understand correctly, in
your subform you have a textbox control which is bound to the Product field, and you want to use a combo box instead of a textbox to enter data into this field. if so, you can change the Product control from a textbox to a combo box. open the form in design view. click on the Product control to select it. on the menu bar, click Format, Change To, Combo Box. now your Product field is bound to a combo box control. just set up the combo box properties to display the list of values you want to select from, and you're done. hth "Wantula" wrote in message ... Im trying to put a combo box on one of the fields (PRODUCT) in the subform of the main form. The form looks exactly like the ORDERS form in the Northwind Database, except that mine doesn't have the last two columns and in the main form there are only two fields(SaleNumber[Auto] and Date) and there is a one to many relationship between the main form and subform. The problem is that everytime I try to place the combo box on the PRODUCT field, it is automatically creating another column next to the last column (Quantity) and places itself there. What could be the problem? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cascading combo box data disappearing from form | Susan L | Using Forms | 7 | November 16th, 2004 05:13 PM |
combo box with query as data source | Simon Wong | Using Forms | 2 | October 14th, 2004 10:13 AM |
Don't allow select in combo box | Sue-Fong | Using Forms | 7 | July 21st, 2004 02:06 PM |
Combo Box Problem | Charles | Using Forms | 0 | May 28th, 2004 09:15 PM |
Requery Combobox | MJ | Running & Setting Up Queries | 7 | May 25th, 2004 11:01 AM |