I have the need to populate a field based on the selection in a combo box.
Starting out simple. (2) tables tbl_OSE_Info and tbl_Input;
tbl_OSE_Info has three fields: Key, OSE_Name and OSE_Wt
tbl_Input has three fields: OSE_Job, OSE_Name, OSE_Wt
I have populated tbl_OSE_Info table.
I need to create a form that will store the data in tbl_Input
I have racked my brain so much trying to figure out how to auto populate a field based on a combo box that I am now second guessing how I created the form.
I have created a form using the wizard.
"Choose the table or query where the object's data comes from:" tbl_Input
I added to the form:
Text field: OSE_Job
Combo Box: checked I want the combo box to look up the values in a table or query. Next>
Selected Table: tbl_OSE_Info, Next>
Selected All Available fields (Key, OSE_Name, OSE_Wt) Next>
Selected Hide key column (recommended) Next>
Selected Store that value in this field: OSE_Name
Labled the combo box OSE_Name.
Properties for Combo Box: cbo_OSE_Name
Name: cbo_OSE_Name
Control Source: OSE_Name
Row Type: Table/Query
Row Source: Select........
Column Count: 3
Column Heads: No
Column Widths: 0";1",1"
Bound Columns: 1
Added the Text field OSE_Wt to the form.
Saved the form as frm_Data
I need to populate the OSE_Wt field on the form base on a selection made in the combo box and have all the data stored in the tbl_Input form.
Please help before the rest of my hair falls out.