Access Subform

[zink421]

How can I tell which record is selected in a subform through code. Help!!!!

 

[GeekGirlau]

You can refer to the value of any field within the selected record. For example,

Forms![main form].[sub form].Form![field name]

 

[Guest_imported]

First, thank you for your advise, I will use your method.
I have a follow up, I want to be able loop through the subform to grab which records (ie key fields) are selected when there is MORE THAN ONE record selected. I know Access will allow this because you can select multiple records and then delete them manually, but I want to be able to program this to accomplish other things.
Jason

 

[Guest_imported]

I want to be able loop through the subform to grab which records (ie key fields) are selected when there is MORE THAN ONE record selected. I know Access will allow this because you can select multiple records and then delete them manually, but I want to be able to program this to accomplish other things.
Jason

 

[zink421]

I have a course form where I need to add students. I have an add studetn form but I need the course code to automatically be filled in the student add form from the course form. They will go to the course for then add student to a particalar course. Can I relate the form in a parent child relationship or do I have to manually program this.

 

[zink421]

Does anyone know how to prevent the pageup/pagedown bottons from scrolling through the recordset on a form? I want to stop this..