Linking form with subform problem

[resolva]

Hey all,

got a problem with a database which should be simple but it doesn't seem to be working.

If you see in my relationships I have a weak entity table between Speakers and Presentations. I am basically trying to make a form so that it has Speakers on and a subform underneath it with the Presentations which that speaker does.

I have tried every way possible of linking them but it doesnt seem to update.

Thank you in advance

 

[boblarson]

If you save the database as a 2000 or 2002-2003 file format, more people can assist. I don't have 2007 here at work so I can't open it to look.

 

[resolva]

Sorry about that, I have uploaded an older version of the database.

Thank you

 

[boblarson]

Here's a quick mockup for you. I set the form to open when you opened the database. Nothing fancy, but the you should get the idea.

 

[resolva]

Thank you Bob!

I am just wondering, could you please make it so that only the available presentation names are in the drop down box? I am not too sure how to do that. At the moment there isnt anything in the drop down boxes to select.

Thank you very much again

 

[boblarson]

At the moment there isnt anything in the drop down boxes to select.

That would be because there isn't anything in the TITLES in the presentation table. Add the titles and they should show up.

 

[resolva]

I just realised that myself

I have also made only the second column show up so can only pick the presentation name.

Sorry to be a pain... but how would i display the presentation start time, end time in other fields when the presentation title is displayed? Is this possible?

 

[boblarson]

I just realised that myself

I have also made only the second column show up so can only pick the presentation name.

Sorry to be a pain... but how would i display the presentation start time, end time in other fields when the presentation title is displayed? Is this possible?

You can put two more text boxes on the form and then refer to the columns in the combo (even if they are just hidden):

=[comboNameHere].[Column](2)
=[comboNameHere].[Column](3)

(columns are zero based so the third column is 2 and the fourth is 3)

 

[resolva]

Thank you again Bob. I have got it working now!

Just another quick query, if you see in my relationships, I will have a form called SPEAKERSCONTACTS which will be used to input new speakers and their personal details.

Is it possible to make it so on the speakers/presentations form when i select a speaker ID (rename speaker name) it will display all the speakers contacts as well as the rest of the form?

I tried doing it like before, but because they are not in the same table i am not sure how to link them.

Thank you