Open form from 2 other forms

[Grimmers]

I have a form f_fish that is opened from f_membership and records filtered based on f-membership!ID. I now want to open the form from another location f_select, but f_membership is not open so it asks me for f_membership!ID. How do I get f_select!ID to equal f_membership!ID ?

I really am a dummy at this.

hope this makes sense!!

cheers,

David

 

[DCrake]

This is a typical issue when using direct references, here is a link to a solution.

Link to Sample Databases

 

[Grimmers]

Thanks for the ultra quick reply, so simple when you know how!!

 

[Grimmers]

I got a bit ahead of myself last night, and didn't really look into your reply DCrake, I am still having issues getting my head around my problem. I can see what your form does but I can't work out how to get my thing working. Basically, what I am trying to do is follows:

If IsLoaded(Forms!f_membership) = True Then
 
    GetMemNo = Forms!f_membership!lngMembershipNo
Else
   
    GetMemNo = Forms!f_SelectFish!List0
End If

Wher GetMemNo filters the data contained in the next form, f_fish. How do i get this code to execute correctly?

cheers,


David

 

[DCrake]

If you create a public variable in a module named StrMemNo

Public LngMemNo As Long

Then in your forms pass the conents of the textbox/selection to the variable


f_membership

LngMemNo = Me.lngMembershipNo

f_SelectFish

LngMemno = Me.List0

Do when you open another form/query/report refer to the LngMemNo as this will remain active for the duration of the open session.

For example When you open a new form

Me.Filter = "[MemberNo]= " & LngMemNo
Me.FilterOn = True

David

 

[Grimmers]

Thanks for your patience David, I've got it now

cheers,

David