Clicking in Record on Subform updates info on parent form?

[CutAndPaste]

I've got a subform which displays some basic details about a client appointment (date & time etc.) Due to space limitations on the sub form I want to display some more detailed information about the client who made the appointment on the parent form.

What I want to happen is that when any part of the individual appointment record is clicked, or has the focus, is that the extra information about the Client that made the visit is updated on the parent form automatically.

I can use DLookUp in the main form info display fields (pulling the data in) , but this only updades if I manually requery the parent via F9. I've tried using unbound fields on the parent form and using DlookUp to update the information fields on the parent form (pushing the data).

None of these seems to work satisfactorily. I'm sure I need to get the requery working properly but can't get my head around what needs to be done. Am I missing something?

Thanks!

 

[namliam]

populate the parent form from the on current of the subform...

Or add a new subform to the parent Linked to the other subform, displaying the details....

Regards

 

[chaps632]

having same issue

I am having the same issue. I have a subform that I want to automatically populate the parent form. I am brand new to Access, so could you explain the DLookup and/or the onCurrent a little further. I'd really appreciate it.