Re Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top