Form to display other table fields associated with combo box then store those values...

[gesouthward]

Hi,



I also posted this in the excelforum.com. Hope that is OK.

I have done multiple searches to try and figure out how to do what I am needing done. I don't think I know enough to ask the right questions.

Attached is a working sample of my database.

In the "Rounding Log" form I need to three associated fields to be populated when an Employee's name is selected from a Combo Box.
The Nickname, Department and Director fields.
Then when the record is complete those fields then be stored in the applicable fields of the "Rounding Log" Table.

I need to be able to do this in order to generate reports from the "Rounding Log" table that are applicable to Departments and Director information.

Hope this make sense and someone can help me.

Thanks,

[ranman256]

If you are editing 1 record,
the combo box has all info of the employee as many columns in the combo.
in the AFTERUPDATE event of the combo, assign the fields,

sub cboBox_afterupdate()
'note, in VB columns start with zero
txtNick= cboBox.column(1)
txtDept=cboBox.column(2)
end sub

[aytee111]

I am not able to open your database at this time, but here goes anyway.

In the Row Source of your combobox include those three fields, set their column width to zero. Then in the OnClick (or AfterUpdate) event of the combobox set each of your three fields to me!comboboxname.column(?)

[gesouthward]

Ranman356 & aytee111,

Thank you very much for the info. That got me going in the right direction.
Now I need to get the data from those text boxes into another table.

I have searched all over, but can't find an example that will work for me.

Is this done with a VBA or some other command?

Thanks,

[aytee111]

An update query should be all you need. If it is immediate then you could run the query in the same event.