Form Autofill/ Autopopulate Help Needed.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.

Ofer said:
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


Str8 said:
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.
Click to expand...
Click to expand...
 
Your welcome, have a great weekend

--
\\// Live Long and Prosper \\//
BS"D


Str8 said:
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.

Ofer said:
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


Str8 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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,

Ofer said:
Your welcome, have a great weekend

--
\\// Live Long and Prosper \\//
BS"D


Str8 said:
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.

Ofer said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top