Lookups on forms

  • Thread starter Thread starter Julian
  • Start date Start date
J

Julian

Could someone please help me.
I have a form that contains 2 combo lists to select items.
List 1 is item codes.
List 2 is the description

What I want to achieve, is: select an item code, the pre-populate another
control with the description.
Also - the ability to select a description (from the 2nd list) and backward
populate the item code.

This is an order form, and I want to make it as easy as possible for people
to use, but I need the information on the form so they can double-check the
order.

Other suggestions would be appreciated.

Many thanks

Julian
 
Thanks Duane

But maybe I'm being a little thick.
I tried using the same control source, but I'm not achieving my end goal.
When I use the same control source, it now populates the 2nd combo box with
the same value as the one selected.
I need to populate the 2nd box with the equivalent value; i.e. description,
based on the selection (item code) from the 1st.

Do you have an example of a line you would use in the control source which
might help me better.

As you'll guess, I'm no Access guru, and an trying to teach myself more,
including VBA.

Your futher assistance would be appreciated.

Many thanks

Julian
 
Your properties of the two combo boxes would be something like:

Name: cboItemCode1
Control Source: [Item Code]
Row Source: SELECT [Item Code], Description FROM tblItems;
Column Count: 2
Bound Column: 1
Column Widths: 1",2"

Name: cboItemCode2
Control Source: [Item Code]
Row Source: SELECT [Item Code], Description FROM tblItems;
Column Count: 2
Bound Column: 1
Column Widths: 0",2"
 
Thanks for your help Duane
You've been a life saver.

Julian


Duane Hookom said:
Your properties of the two combo boxes would be something like:

Name: cboItemCode1
Control Source: [Item Code]
Row Source: SELECT [Item Code], Description FROM tblItems;
Column Count: 2
Bound Column: 1
Column Widths: 1",2"

Name: cboItemCode2
Control Source: [Item Code]
Row Source: SELECT [Item Code], Description FROM tblItems;
Column Count: 2
Bound Column: 1
Column Widths: 0",2"

--
Duane Hookom
MS Access MVP


Julian said:
Thanks Duane

But maybe I'm being a little thick.
I tried using the same control source, but I'm not achieving my end goal.
When I use the same control source, it now populates the 2nd combo box
with the same value as the one selected.
I need to populate the 2nd box with the equivalent value; i.e.
description, based on the selection (item code) from the 1st.

Do you have an example of a line you would use in the control source
which might help me better.

As you'll guess, I'm no Access guru, and an trying to teach myself more,
including VBA.

Your futher assistance would be appreciated.

Many thanks

Julian
Click to expand...
Click to expand...
 
Back
Top