Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Onclick Subform: Move data to a form..

Posted on 2003-11-27
5
Medium Priority
?
310 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

715 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