How to display data on the same form

[Danny]

Hi,

I have created a form for unbound text box for data input, then I will have
a command button for check/add.
Example :
--------------------------------------
Employee : < >
Address : < >
....
....

=====================

However I would like to display all the data that match with the employee
name on the same form say below the "===========" as a datasheet the moment I
completed enter the employee name . How can I do that.

Thanks

 

[Golfinray]

It is probably easier to search by employee name. To do that, have your combo
set up (the wizard can do that for you) with you list of employee names. Then
right click on your combo to go into properties. Go to events, then the
afterupdate event and click the little button to the right. Start the code
builder and type:
Me.filter = "[employees] = """ & Me.combo# & """"
Me.filteron = true
The combo number will be listed, like combo10 or combo22. This will allow
you to pull up and employee name and see all the data about that employee.

 

[Danny]

Hi Golfinray,

Let say I created a table call "schedule", and the fields is "Employee,
Task, Startdate, Enddate, ..etc..etc.."

Then I create a form for enter the data for employee, task, startdate and
enddate..
I have 1 command button for check and add this record into the table
"schedule".
All this entry was enter into a unbound text box.
What I want is that when I start the employee name in the unbound text box,
it start show all the record in the table "schedule" that match with the
employee name on the bottom of the form like display as a datasheet.


--
Danny Boy

It is probably easier to search by employee name. To do that, have your combo
set up (the wizard can do that for you) with you list of employee names. Then
right click on your combo to go into properties. Go to events, then the
afterupdate event and click the little button to the right. Start the code
builder and type:
Me.filter = "[employees] = """ & Me.combo# & """"
Me.filteron = true
The combo number will be listed, like combo10 or combo22. This will allow
you to pull up and employee name and see all the data about that employee.

Hi,

I have created a form for unbound text box for data input, then I will have
a command button for check/add.
Example :
--------------------------------------
Employee : < >
Address : < >
...
...

=====================

However I would like to display all the data that match with the employee
name on the same form say below the "===========" as a datasheet the moment I
completed enter the employee name . How can I do that.

Thanks

 

[Golfinray]

That is what the little program I gave you does. Then you could have a
command button on your form to save.

Hi Golfinray,

Let say I created a table call "schedule", and the fields is "Employee,
Task, Startdate, Enddate, ..etc..etc.."

Then I create a form for enter the data for employee, task, startdate and
enddate..
I have 1 command button for check and add this record into the table
"schedule".
All this entry was enter into a unbound text box.
What I want is that when I start the employee name in the unbound text box,
it start show all the record in the table "schedule" that match with the
employee name on the bottom of the form like display as a datasheet.


--
Danny Boy

It is probably easier to search by employee name. To do that, have your combo
set up (the wizard can do that for you) with you list of employee names. Then
right click on your combo to go into properties. Go to events, then the
afterupdate event and click the little button to the right. Start the code
builder and type:
Me.filter = "[employees] = """ & Me.combo# & """"
Me.filteron = true
The combo number will be listed, like combo10 or combo22. This will allow
you to pull up and employee name and see all the data about that employee.

Hi,

I have created a form for unbound text box for data input, then I will have
a command button for check/add.
Example :
--------------------------------------
Employee : < >
Address : < >
...
...

=====================

However I would like to display all the data that match with the employee
name on the same form say below the "===========" as a datasheet the moment I
completed enter the employee name . How can I do that.

Thanks

 

[Danny]

Hi Golfnray,

ok, thanks. I tried that but nothing come out. When I click on the combo it
does not fire anything.
I'm not sure whether I did it correctly or not or may understand wrongly.
Can you help to explain it in step by step so that I can follow ..

Cheers
--
Danny Boy

That is what the little program I gave you does. Then you could have a
command button on your form to save.

Hi Golfinray,

Let say I created a table call "schedule", and the fields is "Employee,
Task, Startdate, Enddate, ..etc..etc.."

Then I create a form for enter the data for employee, task, startdate and
enddate..
I have 1 command button for check and add this record into the table
"schedule".
All this entry was enter into a unbound text box.
What I want is that when I start the employee name in the unbound text box,
it start show all the record in the table "schedule" that match with the
employee name on the bottom of the form like display as a datasheet.


--
Danny Boy

It is probably easier to search by employee name. To do that, have your combo
set up (the wizard can do that for you) with you list of employee names. Then
right click on your combo to go into properties. Go to events, then the
afterupdate event and click the little button to the right. Start the code
builder and type:
Me.filter = "[employees] = """ & Me.combo# & """"
Me.filteron = true
The combo number will be listed, like combo10 or combo22. This will allow
you to pull up and employee name and see all the data about that employee.

:

Hi,

I have created a form for unbound text box for data input, then I will have
a command button for check/add.
Example :
--------------------------------------
Employee : < >
Address : < >
...
...

=====================

However I would like to display all the data that match with the employee
name on the same form say below the "===========" as a datasheet the moment I
completed enter the employee name . How can I do that.

Thanks