S
Squibbly
how do i create a combo box that as i type enters in the table
i cant seem to do that, what set of properties lets me do that
i cant seem to do that, what set of properties lets me do that
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Squibbly,
I think you want a combo box that when you select one of the selections on
the list, records that selection in your desired table?
If I have interpreted your request correctly, you can simply use the combo
wizard. With your form in the design view make sure your toolbox is open. You
can open the toolbox by the menu; "View" then click "Toolbox". Once your
toolbox is open, make sure your control wizard’s button is depressed. Then
select the combo box tool. Drag your mouse depressing the right mouse button
on the location you want your combo box and release the button. Follow the
wizard’s instructions. If you have a table that has the desired values you
want in the combo menu select I want to look up the values in a table or
query. If not you can choose I will type the values myself. To choose the
values yourself just type them in the order you want them to appear on your
combo list and them choose the field in your table you want the value entered
to.
I you use the "I want to look up the values in a table or query" this is a
good selection especially if you have say a customer table with a CustomerID
field as your primary key (Unique value) and another field with the customers
name. You can choose both fields in the combo wizard and choose which column
is visible i.e. customer name and which column records in your table i.e.,
CustomerID (storing customer names takes more data storage space than a
CustomerID and numbers process faster in access than names/text). If you have
7,000 records and you place a customer name in each record, and the customer
names are repeated many times in your table, your database grows to larger
size than if you have one Customer table with say ten customer names and you
use a CustomerID from that table to post the value in the table in your
original question you will both save space and make queries quicker for
reporting or other uses.
Next name the label or title of your combo box and its done. Check the combo
box properties out noting where and how the wizard entered your information
in the properties to see how to do it without the wizard.
Dennis
I think you want a combo box that when you select one of the selections on
the list, records that selection in your desired table?
If I have interpreted your request correctly, you can simply use the combo
wizard. With your form in the design view make sure your toolbox is open. You
can open the toolbox by the menu; "View" then click "Toolbox". Once your
toolbox is open, make sure your control wizard’s button is depressed. Then
select the combo box tool. Drag your mouse depressing the right mouse button
on the location you want your combo box and release the button. Follow the
wizard’s instructions. If you have a table that has the desired values you
want in the combo menu select I want to look up the values in a table or
query. If not you can choose I will type the values myself. To choose the
values yourself just type them in the order you want them to appear on your
combo list and them choose the field in your table you want the value entered
to.
I you use the "I want to look up the values in a table or query" this is a
good selection especially if you have say a customer table with a CustomerID
field as your primary key (Unique value) and another field with the customers
name. You can choose both fields in the combo wizard and choose which column
is visible i.e. customer name and which column records in your table i.e.,
CustomerID (storing customer names takes more data storage space than a
CustomerID and numbers process faster in access than names/text). If you have
7,000 records and you place a customer name in each record, and the customer
names are repeated many times in your table, your database grows to larger
size than if you have one Customer table with say ten customer names and you
use a CustomerID from that table to post the value in the table in your
original question you will both save space and make queries quicker for
reporting or other uses.
Next name the label or title of your combo box and its done. Check the combo
box properties out noting where and how the wizard entered your information
in the properties to see how to do it without the wizard.
Dennis
J
John Vinson
how do i create a combo box that as i type enters in the table
i cant seem to do that, what set of properties lets me do that
A Combo Box "takes" data from one place - the combo's RowSource query
- and "puts" it into another, its Control Source field. Ordinarily you
don't "type" new data into a combo box; you use the keyboard or the
mouse to *select* a preexisting record from the combo's list of values
or rowsource query.
An example of a combo box might be a State combo in an address form.
Its Rowsource would be a 50 (or 78, counting Canadian provinces and US
territories) row table. The table might contain records like
AB Alberta
AK Alaska
AL Alabama
AR Arkansas
<etc>
The RowSource would be a query on this table, sorting either by
abbreviation or state name.
The Bound Column would be 1 - the abbreviation.
The Column Count might be 1 (if the user only wants to see the
abbreviation) or 2 (if they want to see the state name too, or
instead).
The ControlSource would be the State field in the address table.
John W. Vinson[MVP]
S
Squibbly
no, what i want to do is
like for example want to input new data via the combo box that i have
instead of opening up a form, to where the source of the combo box is from
like for example want to input new data via the combo box that i have
instead of opening up a form, to where the source of the combo box is from