Open form on selected record - continous subform ?

[Lukael]

Hi,

I have a form with continous subform, for which I had added custom right-click context menu.



In this context menu I'm opening 2nd form (with subform also). That form should open in same record as I right-clicked the menu in field of previous form. Context menu is set for text field in continous subform.

This doesn't work, since code for opening form is launched from a module and not from 1st form Itself - so Me! can't work :

DoCmd.OpenForm "YourFormName", , , "[NameOfFieldFromDataSource]='" & Me![NameOfFieldOnFormOpeningFrom] & "'"

What can I do to fix this ??

I'm really struggling with this one, any help much appreciated !!!

[pbaldy]

You'd use the full reference:

Forms Refer to Form and Subform properties and controls

[Lukael]

I had, but this doesn't work also:

DoCmd.OpenForm ""2ndForm",  , , "[FieldName] =' " & Forms![1stForm]![1stFormSubform].Form![SubformField] & " ' "

I think problem is bigger....Just don't know where to start

[pbaldy]

For starters try without the spaces:

DoCmd.OpenForm ""2ndForm", , , "[FieldName] ='" & Forms![1stForm]![1stFormSubform].Form![SubformField] & "'"

Presumably you put the actual names in?

[Lukael]

Presumably you put the actual names in?

Yes I do with actual names, and with no spaces too, I did space here just to see all characters. And this posted code doesn't also solve the selected current record in continous form, I need something like CurrentRecord property, Me! is not working from module.

[pbaldy]

Can you attach the db here?

[Lukael]

I will make example DB, give me 15 minutes. Can't post real one, job application

[Lukael]

Ok,

I have made a sample. Sorry for waiting, couldn't done It so fast. I hope I didn't miss anything....

Instructions:

Open "Form1" - right click on any field in record (continous form). You'll see context menu for opening second form - this is not working !!

disregard code error for context menu - If you'll run code twice, just stop It.

[pbaldy]

Form1 has no subform. This works:

DoCmd.OpenForm "Form2", , , "ID_Table1=" & Forms![Form1]![ID_Table1]

[Lukael]

sorrrrryyy, I see now, you're right.

Take a look at this sample. Same principle, Just open form3. I allready pasted your code in.

So, Is my design wrong, maybe that's why is not working ??


EDIT: Everything I did in this sample is that I created new form, and put Form2 in It, as subform.

[pbaldy]

And what is it you want to do? This doesn't have the ID field in it.

[Lukael]

Yes, this is how I have in my DB. I want to do exactly what you did before.

Let me explain...In real DB I open "search" form, that's my 1st Form. Based on criteria of User, this form then opens a new form with subform - and displays records that match "search" Form criteria.

I have context menu in subform there, and with right-click in It should open a new form - this one has on top of form data from matches, and under that a subform from 2nd table that matches this upper record.

In other words - user searches record, finds It, right-clicks It in continous subform, and new form opens - where he can see what "other Items" are saved to this record (and this other Items are in different table-linked).

I hope you understand this, I't a little bit complicated...

[pbaldy]

I understand conceptually what you want to do. With this sample, when they right click, which form should be opened, and what field's data should be used for matches?

[Lukael]

In this sample: If you open form3, and right-click It, form2 should open, on exatly same record as you clicked in Form3.

You can see desired output, If you just open form2, without doing anything before, that's why I left record selectors on form, I don't have them in my DB.

[pbaldy]

Try

DoCmd.OpenForm "Form2", , , "ID_Table1=" & Forms![Form3]!form1.Form![ID_Table1]