Simple select query question

[Rich G.]

Hi

I am not an experienced Access user and have a Forms issues that I believe
is relatively simple, but beyond my limited technical skills.

I have a form populated with data from Table 1. The form requires user
input to populate one field in the form (a pull down list from created with
the look-up wizard of a field from Table 2. The field contains names of
inventory items). Based on the user's selection in this field, i would like
the next field in my form to automatically display the price, which is
located in the individual records in Table 2.

Any suggestions would be appreciated. I assume some simple type of SELECT
is necessary.

 

[Stefan Hoffmann]

hi Rich,

I have a form populated with data from Table 1. The form requires user
input to populate one field in the form (a pull down list from created with
the look-up wizard of a field from Table 2. The field contains names of
inventory items). Based on the user's selection in this field, i would like
the next field in my form to automatically display the price, which is
located in the individual records in Table 2.

I would add the price field to the ComboBox you already have. You can
use the ColumnWidths property to control the visiblity and hide it.

Then add a TextBox with this ControlSource "=yourComboBoxName.Column(3)".


mfG
--> stefan <--

 

[Marshall Barton]

I am not an experienced Access user and have a Forms issues that I believe
is relatively simple, but beyond my limited technical skills.

I have a form populated with data from Table 1. The form requires user
input to populate one field in the form (a pull down list from created with
the look-up wizard of a field from Table 2. The field contains names of
inventory items). Based on the user's selection in this field, i would like
the next field in my form to automatically display the price, which is
located in the individual records in Table 2.

Include the price field in the combo box's row source query.
Then you can use the AfterUpdate event to populate the text
box:

Me.textbox = Me.combobox.Column(1)