How do I change wizard-created box in a form to a list box-Access

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

Guest

I'm trying to change a Text Box to a List Box in a form that contains a
sub-form. I want to be able to select a field value from a list rather than
click through tons of field values to find the one that contains the subform
and associated data. Another option that would be nice would be to have the
option to type in the value that you are looking for and have the associated
subform appear.
 
The only way I've found is to delete it and use the ListBox wizard to create
a new one.

HTH;

Amy
 
Crmunson311 said:
I'm trying to change a Text Box to a List Box in a form that contains a
sub-form. I want to be able to select a field value from a list rather than
click through tons of field values to find the one that contains the subform
and associated data. Another option that would be nice would be to have the
option to type in the value that you are looking for and have the associated
subform appear.
Click to expand...


In Design mode, click on the text box with the right button. select the
'change to' and choose the listbox.

Bring up the properties and go to the Data tab. in the 'Origin' options
select the origin of your data. You can change the Type of Origin to
table/query and find the origin in a field set the Type to Value and
type in the values.

Hope it helps

Jeff
 
Too cool. Thanks!

-Amy

Jeff said:
In Design mode, click on the text box with the right button. select the
'change to' and choose the listbox.

Bring up the properties and go to the Data tab. in the 'Origin' options
select the origin of your data. You can change the Type of Origin to
table/query and find the origin in a field set the Type to Value and type
in the values.

Hope it helps

Jeff
Click to expand...
 
Thanks for the input! I got it to work using the list box wizard and
maintaining the source (origin) within the form/subform rather than inputting
info from a query.
 
Back
Top