Onclick Subform: Move data to a form..

I just finished from building a search for the db i'm currently working on.. but because of the huge number of colums, it's really hard for the user to move from one to another..

so I figured by using an onlick on the subform (which is the results) it will display the values of the clicked row to a for for easier editing?

I'm lost with no idea on how to do this.. Please adivce :S
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

let me get this straight, you want to provide a list of fields in the mainform, that the user can select (with a checkbox i presume) to include them on the subform such that the user can edit only those fields that were selected in the mainform?

If thats a reasonable description of what youwant to accomplish you have a fair amount of coding to do. One large issue will be placing the controls on the subform in such a way that they are organized for the user, you cant simply put them all there and set the visible proprty if its checked because in the subform you will want them to line up reasonably. if you could do that you would just be doing it on the mainform, and what if they select them all?

have you considered a tab control for this? A tab control allows you to divide your data into coherent groups, each group on it's own page (tab) which becomes visible and editable when the user selects that tab.

Another method would be to "wizard" the form so that the user edits what he needs to and clciks next, at which oint he is presented with a new group of controls, until he reaches the last set.

let me know your thought on my comments.

moodzAuthor Commented:
        I really appreciate your feedback but this is not what I am looking for..
I was surfing around when i found this:


Which I embedded in my db.. Now.. for some reason when it came to "setting the form to the record found" it keeps giving me all kinds of errors.. There is something wrong with this section of the code:

    Dim SyncCriteria As String
    Dim f As Form, rs As Recordset
    'Define the from object and recordset object for the AutoCAD form
    Set f = Forms(Screen.ActiveForm.FormName)
    Set rs = f.RecordsetClone
    ' define the criteria used for the sync
    SyncCriteria = "[YourField]='" & Me![YourField] & "'"
    ' find the corresponding record in the Parts table
    rs.FindFirst SyncCriteria
    f.Bookmark = rs.Bookmark


Now.. heres what i need.. After the search result displayed in the subform, I want the user to click on one of the results (which is in normal table view in the subform), and On Click on the row.. move the data to a form.

hope this gives a better explination..

Waiting ur reply.............
This question has been abandoned and needs to be finalized.
 You can accept an answer, split the points, or get a refund (information at http:/help.jsp#hs5)
  If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)


Cleanup Volunteer

jadedataMS Access Systems CreatorCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next seven days.

EE Cleanup Volunteer
PAQed, with points refunded (125)

E-E Admin

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.