Updatable Cross tab form
Posted on 2011-04-20
I created a form that is retrieving data using a cross tab query. I also have drop down columns with in the form. Since, my cross tab is not updatable how should I go about coding this?
I was thinking of an On change () event
Each row has the primary key is displayed. So, when one of my drop down is selected and changed then update the appropriate table where the primary key equals. I need help writing this. My background is PL/SQL and some C#.Net not VBA.
I'm unsure how to grab the primary key data and store it then grab the selected item that is being updated and modify the source table.