Having problem to get the recordset when double clicked on a list box

[Jo..]

I have problems with a list box for getting recordset on a subform.

my code is

Me.Recordset.FindFirst "[ID]=" & Me.ListBox

where Bound column of the ListBox is the ID.

It just does not seem to be working at all.

Please help. Thank you in advance.

[amrut]

Me.Recordset refers to the Main form and not the SubForm.
Try this assuming ID is a field in the subform.

Me.SubFormControlName.Form.Recordset.FindFirst "[ID]=" & Me.ListBox

[Jo..]

Me.Recordset refers to the Main form and not the SubForm.
Try this assuming ID is a field in the subform.

Me.SubFormControlName.Form.Recordset.FindFirst "[ID]=" & Me.ListBox

Thank you for your reply.

But it come up with a compile error: Method or data member not found.

It used to work before, but it suddenly does not work anymore. So I am wondering if my other code interrupted this code.

[amrut]

Have you replaced the "sub form control name" with your one ??

[Jo..]

Have you replaced the "sub form control name" with your one ??

Yes I did, and it had more error than before. My the list box is in my subform, so i should use me.subform instead?

[Jo..]

I might be having problems with the record selector. It only show one record in the subform. The subform.SourceObject is controlled by the mainform with vba.

my code in the mainform is

Me.Subform.SourceObject = Me.SubCategoryName.Value

Still, the subform record search is not working.

[Jo..]

I think I have got the problem, now I need a solution. My subform is linked with more than one field by default!!! How can I set the link in vba?

[amrut]

Source object for subform cannot be a value, it should be a form. To refer to a control on subform, You have to use the syntax Me.SubformControlName.Form.ControlName. Read more here http://access.mvps.org/access/forms/frm0031.htm

My subform is linked with more than one field by default!!!

Cannot follow this. Source object can be set using the code

Me.Subform.SourceObject = "Form.Name of Form"

Never used VBA to set the Master and Child fields.

[Jo..]

Source object for subform cannot be a value, it should be a form. To refer to a control on subform, You have to use the syntax Me.SubformControlName.Form.ControlName. Read more here http://access.mvps.org/access/forms/frm0031.htm

Cannot follow this. Source object can be set using the code

Me.Subform.SourceObject = "Form.Name of Form"

Never used VBA to set the Master and Child fields.

me.subform.sourceonject= me.textbox.value

The code is right. I got the solution for this one.

The relationship between the main form and subform has more than one link, thats why. After I remove the other link other than the projectid (my key to main form and subform). It is working perfectly.

Thank you so much for your help. This thread is solved.