Solved

Onclick Subform: Move data to a form..

Posted on 2003-11-27
5
285 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
Comment Utility
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
Comment Utility
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
Comment Utility
----------------------------------------------------------------------------------------
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
Comment Utility
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
Comment Utility
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now