Selecting a record from a sub form

[pfales]

Hello,


I am not surehow to properly ask this question but I will try my best. I have a form in which I have included a sub form (frmActivity_List and sfmActivity_List respectively), the sub-form is a list box that will show the specific User (unless they are an admin) only their entries into the database/table. What I would like to do is be able to have the User double click a record and have the selected record entry open for editing by the user. The script I am using is;

 Private Sub Form_DblClick(Cancel As Integer)
DoCmd.Close acForm, "frmActivity_List", acSaveYes
'DoCmd.OpenForm "frmDaily", acNormal, , "DID = " & Me.DID, , , MCreatedBy
DoCmd.OpenForm "frmDaily", , , "DID=" & Me.DID, , , txtUserID
End Sub

I have this script in both the frmActivity_List and sfmActivity_List code windows (hope I said that correctly). The code in a way kind of works because it will open the parent form for editing however it only only picks up the first form in the list box and not the record I have selected. What I mean is lets say there are five records showing in the list box and I select the fourth record in the list. The code runswithout error (amazingly) however when the record opens it is the first record in the list and not the one I selected.

How can I correct this so that the record that is selected is the one that opens?

[rpeare]

Here's an example of using a listbox on a subform

pfales.zip

[pfales]

rpeare,

Thank you for the example that you provided. Thank fully the sub-form populates exactly the way I need it to, my issue is I want the User to be able to select a record in the sub-form and open it to edit the original entry or add to the information contained in the record. What I would like the User to do is double click on the record in the sub-form they want to edit or add information to. When they double click the original record entry will open (in this case my form frmDaily) in edit mode so they can make their changes.
My current code for the double click action does not see anything past the first record in the list contained in the sub-form. What do I need to do to be able to over come this issue? Example the list contains 6 records and I double click on the third record in the list. the current code open the first record, I need for it to open the record I have selected ? How can I do this?What modifications do I need to make to my present code to get this to work?

[rpeare]

I don't understand

If you are using a bound form you don't need to have your click or double click event open another form to update your data.

If I understand you correctly, based on my example, if you click something in the list box of the subform you want to open ANOTHER form named frmDaily that lists that record so you can edit it.

Why open that second form when you don't have to?

[pfales]

I was affraid I was not explaining it correctly.
Let me try it another way, I use frmDaily as the input form for the table, "tblDaily_Task", this is what is utilized to make the task entries into the table/db. When a User signs in to the application the first window/form the will see is the frmActivity_List which contains the sub-form "sfmActivity_List". The sub-form will show the user all the entries that they have made but nothing that anyone else may have made. What I need to be able to do is select one of the record in the sub-form to edit or update the information in that record. what I would like todo is double click the record and have it open in frmDaily (original entry form) to be updated/edited.

[rpeare]

Any chance you can post a sample database (preferably something prior to access 2010 I have very, very limited access to 2010)

[pfales]

Unfortunately I am utilizing Access 2010.

[rpeare]

so post a sample or create a sample and convert it to something prior

[pfales]

subform1.mdb

I have attached the two items you asked for

[rpeare]

Your sample has two forms, frmActivity_List and sfrmActivity_List.

It doesn't include your form frmDaily nor does it include any of the tables that you're working with, need those tables included (just put some fake data in there, enough to simulate your environment) as well.

[pfales]

subform2.accdbsubform3.accdb

Sorry I had to divide it into multiple attachments

[pfales]

subform3.mdbsubform2.mdbsubform1.mdb

Then on top of that I forgot to rename it to an .mdb, Sorry about that

[rpeare]

by the way, putting .mdb as an extension does not convert the database, you have to use the utility within 2010 to do it. I'm taking a look at it now.

[rpeare]

I've combined the parts of your database into the attached file. I don't know why you're putting different objects in different databases for the sample database, but even with the added parts your forms still do not function.

You've devised a function called fOSUsername that is not defined in your sample database.
Your user combo box on the form frmActivity_List is referencing a table that is not in your sample database.

If you add these items into the database I'm attaching then re-post I can take another look.

subform1.zip

[pfales]

subform1a.zip

I apologize I should have let it be known that I am not Access Development knowledgeable, actually just trying to learn (self teach kind of) as I go here. The file =fOSUserName() pulls the users name that is logged in to the computer just like the command "=fnGetUserID()" does I just am more comfortable with the first since I learned it first.