what type of control

  • Thread starter Thread starter nevje
  • Start date Start date
N

nevje

i have an order form and a sub form for the order details ...

i want the user to enter a product number in column 1 on the subform and
in column 2 on the sub form i want the description of the product that
has been entered to show up ... what type of control should i use for
this, ive been playing with combo box's and list box's and they dont
seem to offer what i want
 
nevje said:
i have an order form and a sub form for the order details ...

i want the user to enter a product number in column 1 on the subform and
in column 2 on the sub form i want the description of the product that
has been entered to show up ... what type of control should i use for
this, ive been playing with combo box's and list box's and they dont
seem to offer what i want
Click to expand...

Takes two controls actually. Use a two column ComboBox with the description in
a zero-width second column and then use a TextBox with a ControlSource of...

=ComboBoxName.Column(1)
 
i want the user to enter a product number in column 1 on the subform and
Takes two controls actually. Use a two column ComboBox with the description in
a zero-width second column and then use a TextBox with a ControlSource of...

=ComboBoxName.Column(1)
Click to expand...

thank you ... that was driving me nuts - works great.

as its an information field i dont want it to be part of the tab order -
i can go into properties and choose 'enabled: no' which gives me what i
want but greys out the box - is it possible to have the box not greyed
out but still not editable or part of the tab order?
 
try
Enabled = False
Locked = True

hth


nevje said:
thank you ... that was driving me nuts - works great.

as its an information field i dont want it to be part of the tab order -
i can go into properties and choose 'enabled: no' which gives me what i
want but greys out the box - is it possible to have the box not greyed
out but still not editable or part of the tab order?
Click to expand...
 
try
Enabled = False
Locked = True

hth
Click to expand...

thank you, again - works just as i was after

access is sure taking some getting used to although now this particular
part of the database working its just a matter of tidy up and making it
usable for the user before moving onto queries/reports/output which i
havent tackled before at all so looking forward to that .... so thanks
folks
 
Back
Top