Calls command button in Contacts database

[Clifford F. Lewis]

I have created a database based on the Contact Management template. In
the contacts form, there is a button marked Calls... that brings up a
form that records call dates and times and notes for that contact.

I have been trying to create a Meetings... button that has a similar
functionality. As far as I can tell, everything is the same. The
meetings form has subforms for meeting listings and meeting details.
The properties and the VB code are identical except for references to
the Meetings table substituted for references to the Calls table.

When I open the Meetings form, I get a dialog prompting me for a
MeetingID. That is an autonumber field in the table, but there is no
control for it in the Meetings form. (I cannot find one for the CallID
in the Calls form either.) If I supply a MeetingID number, the form
appears and I can fill in the Meeting Listing subform, but when I
start typing in the Meeting Details subform, I get an error message
saying, "The LinkMasterFields property setting has produced this
error: 'The object doesn't contain the Automation object 'MeetingID.''

Can anyone tell me where I am going wrong?

 

[PC Datasheet]

It sounds like you have a form based on a query and the query does not
contain the MeetingID field.

 

[Clifford F. Lewis]

Where would I find that query?

 

[PC Datasheet]

Open your meetings form in design view. Open properties, go to the Data tab
and look at the record source property. Click on the three dots at the right
to open the record source. See if it is a query or table and if it has a
field MeetingID. If it does, do the same for each subform. I suspect that
since you converted a Calls database to a Meetings database, somewhere you
missed changing CallID to MeetingID.

Steve
PC Datasheet

 

[Clifford F. Lewis]

Ah, this is where I am having trouble. Every time I click on a
different part of the form I get a different property dialog. I get
one if I click on the title bar, another if I click on the ruler,
another if I click on the form body, another if I click on a
particular field in the form, and yet another if I click on the box in
the upper left corner. On top of that, sometimes I get a different
result clicking on one part of a form if a field in another part is
selected. How can I hope to find everything?

Just now I noticed a CallID edit control peeking out from behind the
Meeting Listing subform in design view. I had not seen that before,
and it is flagged non-visible. Sure enough, when I changed that to
MeetingID, that took care of the problem.

It would be nice if there were a way to get a listing of all the
controls in a form in one place.

Cliff

 

[PC Datasheet]

<<It would be nice if there were a way to get a listing of all the controls
in a form in one place.>>

There is a way! Open your form in design view. Click on the down arrow in
the dropdown list on the toolbar at the far left. Select an item from the
list and it will be selected.

Steve
PC Datasheet