G
Guest
Where can I find Combo Box Wizard to pull info from a table and place in a form
Thank you
Thank you
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.
B
Bruce
Click View > Tools. When the toolbox appears, click the
magic wand in the middle of the top row if it is not
already lit, click the combo box icon, and click in the
form.
magic wand in the middle of the top row if it is not
already lit, click the combo box icon, and click in the
form.
K
Kevin Sprinkel
The wizard automatically appears when attempting to add a
new combo box IF the Wizard toggle button is depressed.
The button, which looks like a wand and five stars, is on
the the Toolbox toolbar. Choose, View, Toolbox if it is
not currently visible.
HTH
Kevin Sprinkel
new combo box IF the Wizard toggle button is depressed.
The button, which looks like a wand and five stars, is on
the the Toolbox toolbar. Choose, View, Toolbox if it is
not currently visible.
HTH
Kevin Sprinkel
K
Kevin Sprinkel
By "auto-fill", do you mean *display* all of this
information on your form, or *store* these fields
redundantly in your form's underlying table? If you're
trying to do the latter, it is not necessary and
undesirable. Store just the primary key in your form's
underlying table, and remove the redundant fields from its
definition.
If, though, you merely want to display these fields, base
your form on a multi-table query that includes fields,
joining the tables by the CarrierID field. Then when you
change the CarrierID field, the other controls will
display the appropriate values for that carrier.
HTH
Kevin Sprinkel
city, st, zip, phone, fax
address, city, etc. based on fields in Carriers Table.
information on your form, or *store* these fields
redundantly in your form's underlying table? If you're
trying to do the latter, it is not necessary and
undesirable. Store just the primary key in your form's
underlying table, and remove the redundant fields from its
definition.
If, though, you merely want to display these fields, base
your form on a multi-table query that includes fields,
joining the tables by the CarrierID field. Then when you
change the CarrierID field, the other controls will
display the appropriate values for that carrier.
HTH
Kevin Sprinkel
Top part of form contains "Carrier" info - name, address,-----Original Message-----
I found it, thanks guys!
I just can't get it to do what I want!
I have a confirmation form with "truck load" information.
city, st, zip, phone, fax
of Carrier name and have it auto-fill rest of name,I want the user to be able to type in first few letters
address, city, etc. based on fields in Carriers Table.