A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Updating table from subform



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2008, 01:25 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default Updating table from subform

I have a subform were I enter dates that people have been trained in working
instructions, these instructions are linked to positions held. The problem
arises when I link more than one person to a position and hence a work
instruction. When I enter a date in the subform for a particular work
instruction and position it changes the date for any other person that has
been trained in that same positions work instruction.
  #2  
Old April 14th, 2008, 01:41 AM posted to microsoft.public.access.forms
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default Updating table from subform

Include a field for the Person in the subform's RecordSource query so that
you are uniquely changing only that person's record.
--

Ken Snell
MS ACCESS MVP



"Try Hard" wrote in message
...
I have a subform were I enter dates that people have been trained in
working
instructions, these instructions are linked to positions held. The problem
arises when I link more than one person to a position and hence a work
instruction. When I enter a date in the subform for a particular work
instruction and position it changes the date for any other person that has
been trained in that same positions work instruction.



  #3  
Old April 14th, 2008, 02:08 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default Updating table from subform

Ken, thanks mate. I have a couple of another questions? I have changed the
RecordSource as you indicated and yes this worked, but, the record I inputed
is not displayed in the subform (I dont know were Im up to) and can I have
all the records in the subform rather than selecting them by a combo box?
Again your help would be apprecited.

"Ken Snell (MVP)" wrote:

Include a field for the Person in the subform's RecordSource query so that
you are uniquely changing only that person's record.
--

Ken Snell
MS ACCESS MVP



"Try Hard" wrote in message
...
I have a subform were I enter dates that people have been trained in
working
instructions, these instructions are linked to positions held. The problem
arises when I link more than one person to a position and hence a work
instruction. When I enter a date in the subform for a particular work
instruction and position it changes the date for any other person that has
been trained in that same positions work instruction.




  #4  
Old April 15th, 2008, 02:56 AM posted to microsoft.public.access.forms
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default Updating table from subform

Did you also add the Person field to the LinkChildFields and the Person
combobox to the LinkMasterFields properties of the subform control (the
control that actually holds the subform object)?

--

Ken Snell
MS ACCESS MVP


"Try Hard" wrote in message
...
Ken, thanks mate. I have a couple of another questions? I have changed the
RecordSource as you indicated and yes this worked, but, the record I
inputed
is not displayed in the subform (I dont know were Im up to) and can I have
all the records in the subform rather than selecting them by a combo box?
Again your help would be apprecited.

"Ken Snell (MVP)" wrote:

Include a field for the Person in the subform's RecordSource query so
that
you are uniquely changing only that person's record.
--

Ken Snell
MS ACCESS MVP



"Try Hard" wrote in message
...
I have a subform were I enter dates that people have been trained in
working
instructions, these instructions are linked to positions held. The
problem
arises when I link more than one person to a position and hence a work
instruction. When I enter a date in the subform for a particular work
instruction and position it changes the date for any other person that
has
been trained in that same positions work instruction.






  #5  
Old April 15th, 2008, 07:24 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default Updating table from subform

Thanks Ken

"Ken Snell (MVP)" wrote:

Did you also add the Person field to the LinkChildFields and the Person
combobox to the LinkMasterFields properties of the subform control (the
control that actually holds the subform object)?

--

Ken Snell
MS ACCESS MVP


"Try Hard" wrote in message
...
Ken, thanks mate. I have a couple of another questions? I have changed the
RecordSource as you indicated and yes this worked, but, the record I
inputed
is not displayed in the subform (I dont know were Im up to) and can I have
all the records in the subform rather than selecting them by a combo box?
Again your help would be apprecited.

"Ken Snell (MVP)" wrote:

Include a field for the Person in the subform's RecordSource query so
that
you are uniquely changing only that person's record.
--

Ken Snell
MS ACCESS MVP



"Try Hard" wrote in message
...
I have a subform were I enter dates that people have been trained in
working
instructions, these instructions are linked to positions held. The
problem
arises when I link more than one person to a position and hence a work
instruction. When I enter a date in the subform for a particular work
instruction and position it changes the date for any other person that
has
been trained in that same positions work instruction.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.