I have a form, formCreatenewEvent
on this form I can create new events...
I want to be able to update events as well.
So, I have main home form... on there I have a button to update form... then 2 combo boxes and a text box..
The first combo box you select the date of the event, 2nd combo box you select the title of the event...
and the text box needs to pull the type of event EventType field. from my tblEvent
Then I need to press a button, and have this open my formCreateEvent form up to the event selected on the previous form... Also, i have 4 different types of events, each one has a different createnewevent form... ex. formCreateHGEvent formCreateREEvent..
So, I need help coding the combo boxes and text box and button to pass the info to the correct form and open to that record so I can edit then save it.
I have the method on how to populate the Event titles by date... so now I need how to pass the event type(text box) and have a proper if txtboxEventType = RE Event ... docmd.openform CreateREEvent.
Any help?
on this form I can create new events...
I want to be able to update events as well.
So, I have main home form... on there I have a button to update form... then 2 combo boxes and a text box..
The first combo box you select the date of the event, 2nd combo box you select the title of the event...
and the text box needs to pull the type of event EventType field. from my tblEvent
Then I need to press a button, and have this open my formCreateEvent form up to the event selected on the previous form... Also, i have 4 different types of events, each one has a different createnewevent form... ex. formCreateHGEvent formCreateREEvent..
So, I need help coding the combo boxes and text box and button to pass the info to the correct form and open to that record so I can edit then save it.
I have the method on how to populate the Event titles by date... so now I need how to pass the event type(text box) and have a proper if txtboxEventType = RE Event ... docmd.openform CreateREEvent.
Any help?