dscarbor
Last Activity: Jul 26 '07, 09:14 PM
Joined: Jul 26 '07
Location:
-
dscarbor replied to Use a button to update a field in parent form based on record selected in subform?in AccessNevermind!!! I'm an idiot...the field name wasn't Field1...I had aliased it in the query. Sorry and thanks for all your help!!!... -
dscarbor replied to Use a button to update a field in parent form based on record selected in subform?in AccessThanks for the quick reply. I've got to be getting close, but I'm getting an error.
The name of the main form is "AssignIds" . The field in that form to be updated is "NewID". The name of the subform is "Pass2 subform" and the Field to pull from (primary key) is "Field1". I wrote the below, but it is erroring out:
Forms!AssignIds !NewID = Forms!AssignIds ![Pass2 subform].Form.Field1...Leave a comment:
-
dscarbor replied to Use a button to update a field in parent form based on record selected in subform?in AccessSorry, to be more explicit:
If I want Field1 of the SELECTED record in the subform, and to update the active record in the parent form...
Is the selected record something like:
Forms!Subform!F ield1
Or is there some tag like ".selected" that I need in there?
I think once I have that, it's a matter of a simple update query that uses that item.
Thanks!...Leave a comment:
-
dscarbor replied to Use a button to update a field in parent form based on record selected in subform?in AccessSo if I want to pull the PK of the selected record on the subform, what would that be?
Forms!Form1!???Leave a comment:
-
dscarbor started a topic Use a button to update a field in parent form based on record selected in subform?in AccessUse a button to update a field in parent form based on record selected in subform?
I have a simple form with 4 fields, and a subform that retrieves records that are potential matches based on a query.
The user will use the ID from the subform record and enter it into one of the fields on the main form (this is how the match will be stored).
Is there a way using a button/macro to populate the parent form's field with the ID of the subform record that is currently selected?
For example,...
No activity results to display
Leave a comment: