Solved

Onclick Subform: Move data to a form..

Posted on 2003-11-27
5
298 Views
Last Modified: 2010-07-27
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
0
Comment
Question by:moodz
5 Comments
 
LVL 10

Expert Comment

by:jobrienct
ID: 9835542
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.

John
0
 

Author Comment

by:moodz
ID: 9835575
John,
        I really appreciate your feedback but this is not what I am looking for..
I was surfing around when i found this:

http://www.tek-tips.com/gfaqs.cfm/pid/702/fid/1177

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.............
0
 
LVL 9

Expert Comment

by:ornicar
ID: 10075246
----------------------------------------------------------------------------------------
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/)

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

ornicar
Cleanup Volunteer

---------------------------------------------------------------------------------------------
0
 
LVL 32

Expert Comment

by:jadedata
ID: 10105790
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.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

jadedata
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10160654
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question