I am working in Access 2007.
I have a Main Switchboard form that lists all the records in an Event table. The purpose of this form is to show, at a glance, all the events. The only fields it shows is the EventName, startDate, endDate, and City. There is a command button that can be clicked to take the user to the Event form which shows all the details of the event. The command button has an On Click event that has an embedded macro to open the form frmEvent where = "[EventID] = " & [EventID].
What I am trying to do is also use this Main Switchboard to allow the user to enter new event information, click the command button and be taken to the Event form with these fields already populated. If I enter new data into the fields and tab to the next line then go back and click the command button it works just fine but that's kinda hinky. I would like to just enter the data and click the command button.
I hope that makes sense. Is there a way to do this?
TIA!
~RLG
I have a Main Switchboard form that lists all the records in an Event table. The purpose of this form is to show, at a glance, all the events. The only fields it shows is the EventName, startDate, endDate, and City. There is a command button that can be clicked to take the user to the Event form which shows all the details of the event. The command button has an On Click event that has an embedded macro to open the form frmEvent where = "[EventID] = " & [EventID].
What I am trying to do is also use this Main Switchboard to allow the user to enter new event information, click the command button and be taken to the Event form with these fields already populated. If I enter new data into the fields and tab to the next line then go back and click the command button it works just fine but that's kinda hinky. I would like to just enter the data and click the command button.
I hope that makes sense. Is there a way to do this?
TIA!
~RLG
