I have a form called frmSales which has three datagridviews on it which are
linked to a Cinema.mdb database using SQL. The first datagridview (Film)
displays the FilmNumber(Unique Key) and FullTitle of the Film, the second
datagridview (Date) displays the days the film is on for and the third
datagridview (Session) displays SessionNo(Unique Key), Time, Cinema and
SeatNumbers. I have two buttons on this form called Sales and the other
called Return.
What I need help with is the code for the buttons so that when the user has
selected the three datagridviews and depending on whether Cinema 1 or Cinema
2 was selected in datagridview Session then when either the Sales or Return
button is pressed they will be taken to the corresponding Cinema form (In
this case either frmCinema1 or frmCinema2).
Any help would be appreciated.
Cheers,
Kryt0n1t3