Enter Paramter Value

[Hokie]

Hi,

Whenever I open the form 'TrainingF' I get the 'Enter Parameter Value' msg box. I tried to look online but could not get rid of it. Please help me. I have attached the file. Please help me. Thank you.

 

[plog]

It's because the Record source of the form is based on that field. Design view->Form Properties->Record Source:

SELECT TraningT.TrainingID, TraningT.TrainingTitle, TraningT.Start, TraningT.End
 , TraningT.Duration, [COLOR="Red"]TraningT.Project[/COLOR], TraningT.NumberofParticipants, TraningT.DescriptionofParticipants
 , TraningT.[Venue], TraningT.ProjectLeader, TraningT.ProjectCoordinator1, TraningT.ProjectCoordinator2
 , TraningT.[GrossIncome(USD)], TraningT.[NetIncome(USD)], TraningT.[Expenses(USD)]
 , TraningT.[GrossIncome(THB)], TraningT.[NetIncome(THB)], TraningT.[Expenses(THB)]
FROM TraningT;

Why's it based on SQL and not just TrainingT?

 

[Hokie]

Plog, thank you for your answer. I am not sure why the record source of the form is based on that field.. Probably, I clicked on something and something happened. I am new to the program. Please kindly inform me how I should fix it. Thank you.

 

[plog]

Do you see where that query exists as the Record source on your form? Design View of the Form->Form Properties->Record Source.

You will find what I posted there. You should change it to:

TrainingT

 

[Hokie]

Plog thank you again for the solution.

 

[Hokie]

I have another question. In my table I have a field named 'Venue'. I want users to have the option to select more than one option from the drop down list. How do I do that?

 

[plog]

For that you need a new table. You would create a TrainingVenue table and it would have at least these 2 fields:

TrainingVenue
ID_Training, ID_Venue
17, 81
17, 29
14, 38

ID_Training would link back to the primary key of Training table and ID_Venue would link back to the primary key of your Venue table. If each venue had its own dates you would put that in the TrainingVenue table as well as any information related to that specific pairing.

When it comes to forms, you would implement this with a TrainingVenue subform on the Training form.