Sub Form In Datasheet View

[mcgj]

I have a form that contains a sub form that is viewed as a datasheet. They
are linked by a single integer field (master/child). I want be able to get
information from the record in the sub form when the user clicks in one of
the text boxes within that record's line in the datasheet. So can I use some
tool or code to find out which record the user has selected?

Thanks for your help!

 

[Ofer Cohen]

Do you want to refer to that value from the main form?
You can try
Me.[SubFormControlName].Form![TextBoxName]

Or to refer to a text box from a query or out side the form
Forms![MainFormName]![SubFormControlName].Form![TextBoxName]

You can use that also from the main form

 

[mcgj]

Thanks for your help. When I use this type of lingo in the code I get the
information for the first record in the datasheet. That is fine when that is
the selected row but when there is more than one record and the user selects
the third row for instance how do I get the data from that row/record?

Thanks!

Do you want to refer to that value from the main form?
You can try
Me.[SubFormControlName].Form![TextBoxName]

Or to refer to a text box from a query or out side the form
Forms![MainFormName]![SubFormControlName].Form![TextBoxName]

You can use that also from the main form

--
Good Luck
BS"D

I have a form that contains a sub form that is viewed as a datasheet. They
are linked by a single integer field (master/child). I want be able to get
information from the record in the sub form when the user clicks in one of
the text boxes within that record's line in the datasheet. So can I use some
tool or code to find out which record the user has selected?

Thanks for your help!

 

[Ofer Cohen]

You can use the OnCurrent event of the SubForm to assign the value to the
text box in the main form

Me.Parent.[TextBoxNameInMainForm] = Me.[TextBoxNameInSubForm]

That way this event will be triggered everytime you move a record

--
Good Luck
BS"D

Thanks for your help. When I use this type of lingo in the code I get the
information for the first record in the datasheet. That is fine when that is
the selected row but when there is more than one record and the user selects
the third row for instance how do I get the data from that row/record?

Thanks!

Do you want to refer to that value from the main form?
You can try
Me.[SubFormControlName].Form![TextBoxName]

Or to refer to a text box from a query or out side the form
Forms![MainFormName]![SubFormControlName].Form![TextBoxName]

You can use that also from the main form

--
Good Luck
BS"D

I have a form that contains a sub form that is viewed as a datasheet. They
are linked by a single integer field (master/child). I want be able to get
information from the record in the sub form when the user clicks in one of
the text boxes within that record's line in the datasheet. So can I use some
tool or code to find out which record the user has selected?

Thanks for your help!

 

[mcgj]

That did Ofer. Thanks!

You can use the OnCurrent event of the SubForm to assign the value to the
text box in the main form

Me.Parent.[TextBoxNameInMainForm] = Me.[TextBoxNameInSubForm]

That way this event will be triggered everytime you move a record

--
Good Luck
BS"D

Thanks for your help. When I use this type of lingo in the code I get the
information for the first record in the datasheet. That is fine when that is
the selected row but when there is more than one record and the user selects
the third row for instance how do I get the data from that row/record?

Thanks!

Do you want to refer to that value from the main form?
You can try
Me.[SubFormControlName].Form![TextBoxName]

Or to refer to a text box from a query or out side the form
Forms![MainFormName]![SubFormControlName].Form![TextBoxName]

You can use that also from the main form

--
Good Luck
BS"D


:

I have a form that contains a sub form that is viewed as a datasheet. They
are linked by a single integer field (master/child). I want be able to get
information from the record in the sub form when the user clicks in one of
the text boxes within that record's line in the datasheet. So can I use some
tool or code to find out which record the user has selected?

Thanks for your help!