Ok, so i am beginning to build a very extensive database, RIght now there is some random "test data" in their to practice with. To give some background on what I am trying to do..
I am trying to build a database where I can manage clients and events. I will be creating and hosting events and will be having new clients signing up to go to these events, sometimes i will even have returning clients as well. I will also have employees as well. I am trying to organize this data so i can manage it easily. That way when i have a new event, I will be able to select the event and then add the clients who have signed up for the event with ease ( i have not yet added the "ADD NEW CLIENT " feature, will work on that later).
My question is regarding a form that i have Called "Frm_Organized events" I am trying to have this form be my main form as I will have already entered the "event information such as Location, date, etc. My first issue I am having is that I am able to successfully pull in an event using the combo box, however when i try to add a another box that I would like to pull the date that is ASSOCIATED with that specific event, it make sit so the entire form is blank when i go into the 'Form view"
How can i make this form pull data that I already have entered using my above example?
I have inserted a ZIP of the database I currently have explained above. ANy helpful advice would be greatly appreciated.
Events-Database - Copy.zip