>hello! im wondering if somethings posible.
>
>likes i have this grid from a View...that View is from a table is there a way like when i select /click a row that the data is reflected to my fields?and i can be allowed to edit? is this even possible?if so what does the control source of my field supposed to be the view or the table which the view is formulated from
Yes, it's a very common scenario. (Grid at the top, record data bellow - or record editing form may be even a separate form).
In the AfterRowColChange event of the grid you do
thisform.refresh()
Both form and grid are bound to the same table/view, but the grid is set in readonly mode.
Your view must be an updatable view.
I also have this as two pagespageframe form - first is a Grid View and second is a one record view with all fields.
If it's not broken, fix it until it is.
My Blog