call listing/detail subform issues

[redknite]

I have a form used to display properties. I found a sample database that had a call history log in it. It has 1 table and 2 subforms on a third form. One that lists the calls in datasheet view and displays call date, call time, and the call result, and another that has a big text box that displays the notes stored in the corresponding call record.
Call date and time fields are supplied with the default values of the current date and time. When this was in it's original database it worked fine. In mine though (I transferred first the table then the 2 subforms, then copied the portion of the master form into my database) I am having a problem witht the call details portion. I have the call listings subfrom linked to my master table and it's doing what it's supposed to. The details form in the original database has CallID linked to CallID on master and subforms. When I do this and then try to view the form to enter data, a msgbox displays saying "CallID=" Does anyone know how to help? Does that even make sense?

 

[vbaInet]

Click on the elipsis (...) button on either the Link Master Field or Link Child Field property and select from the list.

 

[redknite]

thanks for the reply. I understand linking master to child. In the calllisting subform i link the property ID in master to callID in child. However I don't know what to put in the calldetails child and master link forms. Any suggestions?

 

[vbaInet]

Is the record source of calldetails a different table from calllistings?

Explain how they should be linked. Maybe show us a screenshot of your Relationships diagram and a screenshot of the form.

 

[redknite]

Thanks for your help. Sorry it took so long to reply. I've changed "call" to "note" All note information is in one table.


I've attached the form picture and relationship picture.

Thanks again.

 

[vbaInet]

Without any explanations or labels those screenshots don't really help. Can you explain what you want to link from the screenshot.

 

[redknite]

The first is the form that I want to use. In the top section that is where the notes are placed. Now if i want more details for the note, the bottom section is the "note Details" which is a another field from the same table. When i click on the second row of the top form, the bottom section should move to the same record set as is being activated in the top. Does that make sense?

 

[vbaInet]

Does that make sense?

Absolument!

I will offer two ways:

1. Use a subform that includes the ID (which you will use to link to the subform) and the Notes field. That way you don't have to code anything to get it to update.

OR

2. Do it in code. Set the control's value to the current Notes field in the subform on the Current event of the form, then on the After Update of the Notes textbox, set the Notes field value to the Notes textbox value. Something like:

Form's On Current:
Me.txtNotes.Value = Forms!SubformName!NotesField

Notes textbox's After Update:
Forms!SubformName!NotesField = Me.txtNotes.Value