filling in data

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

Guest

I have a form that has Emp #, Emp name, Bureau, Division, in the top, I have
a subform attatched that I want data entry to enter information. The top
part I want to be able to type in the Emp # and it will look into the
Employee database which I have imported and fill in the the name, bureau and
division. I created a query that when I open the form it asks for the emp #,
when I type the emp# it opens the form with that record. But now it will
not allow me to go to the emp# field and type another emp#. How can I
another emp# to pull that infor in to the form so I can add the new infor in
my subform? I am not a vb programmer and hope this will be a simple
function. HELP.......
 
Create a combo in the Top of the form, that has

Select [Emp #], [Emp name], Bureau, Division From QueryName
In the Row source
ColumnCount Property = 4
=======================================
Chenge the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
=======================================
The user can either type the Emp # or select it from the list
And you don't need to prompt the user for emp # when the form comes up
And the fields will be field Automatically with data
 
I get a #Name? error when I go to change the control source of the text
boxes in the form to:
Change the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
Click to expand...
What am I doing wrong?


Ofer said:
Create a combo in the Top of the form, that has

Select [Emp #], [Emp name], Bureau, Division From QueryName
In the Row source
ColumnCount Property = 4
=======================================
Chenge the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
=======================================
The user can either type the Emp # or select it from the list
And you don't need to prompt the user for emp # when the form comes up
And the fields will be field Automatically with data
--
I hope that helped
Good luck


Pam Coleman said:
I have a form that has Emp #, Emp name, Bureau, Division, in the top, I have
a subform attatched that I want data entry to enter information. The top
part I want to be able to type in the Emp # and it will look into the
Employee database which I have imported and fill in the the name, bureau and
division. I created a query that when I open the form it asks for the emp #,
when I type the emp# it opens the form with that record. But now it will
not allow me to go to the emp# field and type another emp#. How can I
another emp# to pull that infor in to the form so I can add the new infor in
my subform? I am not a vb programmer and hope this will be a simple
function. HELP.......
Click to expand...
Click to expand...
 
Sorry, its my mistake, it shouldn't include the Me

=[ComboName].column(1)

--
I hope that helped
Good luck


Pam Coleman said:
I get a #Name? error when I go to change the control source of the text
boxes in the form to:
Change the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
Click to expand...
What am I doing wrong?


Ofer said:
Create a combo in the Top of the form, that has

Select [Emp #], [Emp name], Bureau, Division From QueryName
In the Row source
ColumnCount Property = 4
=======================================
Chenge the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
=======================================
The user can either type the Emp # or select it from the list
And you don't need to prompt the user for emp # when the form comes up
And the fields will be field Automatically with data
--
I hope that helped
Good luck


Pam Coleman said:
I have a form that has Emp #, Emp name, Bureau, Division, in the top, I have
a subform attatched that I want data entry to enter information. The top
part I want to be able to type in the Emp # and it will look into the
Employee database which I have imported and fill in the the name, bureau and
division. I created a query that when I open the form it asks for the emp #,
when I type the emp# it opens the form with that record. But now it will
not allow me to go to the emp# field and type another emp#. How can I
another emp# to pull that infor in to the form so I can add the new infor in
my subform? I am not a vb programmer and hope this will be a simple
function. HELP.......
Click to expand...
Click to expand...
Click to expand...
 
Thank you, it works.

Ofer said:
Sorry, its my mistake, it shouldn't include the Me

=[ComboName].column(1)

--
I hope that helped
Good luck


Pam Coleman said:
I get a #Name? error when I go to change the control source of the text
boxes in the form to:
Change the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
Click to expand...
What am I doing wrong?


Ofer said:
Create a combo in the Top of the form, that has

Select [Emp #], [Emp name], Bureau, Division From QueryName
In the Row source
ColumnCount Property = 4
=======================================
Chenge the control source of the text boxes in the form
For [Emp name]
=Me.ComboName.column(1)
For [Bureau]
=Me.ComboName.column(2)
For [Division]
=Me.ComboName.column(3)
=======================================
The user can either type the Emp # or select it from the list
And you don't need to prompt the user for emp # when the form comes up
And the fields will be field Automatically with data
--
I hope that helped
Good luck


:

I have a form that has Emp #, Emp name, Bureau, Division, in the top, I have
a subform attatched that I want data entry to enter information. The top
part I want to be able to type in the Emp # and it will look into the
Employee database which I have imported and fill in the the name, bureau and
division. I created a query that when I open the form it asks for the emp #,
when I type the emp# it opens the form with that record. But now it will
not allow me to go to the emp# field and type another emp#. How can I
another emp# to pull that infor in to the form so I can add the new infor in
my subform? I am not a vb programmer and hope this will be a simple
function. HELP.......
Click to expand...
Click to expand...
Click to expand...
 
Back
Top