Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Subform

Status
Not open for further replies.

zink421

Programmer
Aug 21, 2001
16
US
How can I tell which record is selected in a subform through code. Help!!!!
 
You can refer to the value of any field within the selected record. For example,

Forms![main form].[sub form].Form![field name]
 
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
 
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
 
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.
 
Does anyone know how to prevent the pageup/pagedown bottons from scrolling through the recordset on a form? I want to stop this..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top