G
Guest
I just realized a problem. I have a table that the info on this form dumps
into. When using this autopopulate it works great on the form but's doesn't
dump the fields that auotofilled into my table.
Any ideas?
Thanks,
:
Your welcome, have a great weekend
--
\\// Live Long and Prosper \\//
BS"D
:
Thanks Ofer you really made my day. I've been working on this off and on for
about a week and couldn't get it to work. I tried something simular but
didn't work.
This works perfect.
Thanks again.
:
In the RowSource of the combo, include all the fields from the table that
you
want to display in the form
Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties
ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control Source
property
Sup text box write
=[ComboName].Column(1)
Manager text box write
=[ComboName].Column(2)
[Site Manager] text box write
=[ComboName].Column(3)
===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes
--
\\// Live Long and Prosper \\//
BS"D
:
This ones probably pretty easy but I cant get it to work.
Ok I just created a new DB. I have one table call "Employee" that has Site
Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd, and
Employee in the 4th column. I have a Form that has 4 lines Employee, Sup,
Manager, Site Manager. I want to use a drop down in the Employee field and
when you choose the Employee it looks back at the "Employee Table" and Auto
Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.
into. When using this autopopulate it works great on the form but's doesn't
dump the fields that auotofilled into my table.
Any ideas?
Thanks,
:
Your welcome, have a great weekend
--
\\// Live Long and Prosper \\//
BS"D
:
Thanks Ofer you really made my day. I've been working on this off and on for
about a week and couldn't get it to work. I tried something simular but
didn't work.
This works perfect.
Thanks again.
:
In the RowSource of the combo, include all the fields from the table that
you
want to display in the form
Select Employee, Sup, Manager, [Site Manager] From Employee
============================================
In the combo Set the following properties
ColumnCount Property: 4
ColumnWidths Property: 3;0;0;0
============================================
Create three text boxes in the form, and in each write in the Control Source
property
Sup text box write
=[ComboName].Column(1)
Manager text box write
=[ComboName].Column(2)
[Site Manager] text box write
=[ComboName].Column(3)
===================================
After you select a value in the combo, the rest of the values will be
populated to the rest of the text boxes
--
\\// Live Long and Prosper \\//
BS"D
:
This ones probably pretty easy but I cant get it to work.
Ok I just created a new DB. I have one table call "Employee" that has Site
Manager in the 1st Column, Manager in the 2nd, Supervisor in the 3rd, and
Employee in the 4th column. I have a Form that has 4 lines Employee, Sup,
Manager, Site Manager. I want to use a drop down in the Employee field and
when you choose the Employee it looks back at the "Employee Table" and Auto
Fills in the Employees Sup, Manager, and Site Manager in the form.
Hopefully this made since.