Filter data in one form using a key field in a continuous form

[amai]

As a continuous form cannot have a subform, I created a main table in continuous form. Then I created the subtable in datasheet view form. I added both forms side by side in another form. Now, what I want to do is to navigate through the main form (continuous form) and filter the subform (datasheet) based on the row I select in the main form.



Is there any way I can do this?

Please consider that I am very new to Access. I have been successful applying simple VBA codes. However, if it is very complicated, I might not be able to apply it. If that is the case, I will appreciate if you suggest an alternative to the form.

Thank you in advance.

[pbaldy]

In the current event of tehcontinuous form try:

Forms!MainFormName.SubformControlName.Form.Filter = "InvoiceNumber = " & Me.InvoiceNumber
Forms!MainFormName.SubformControlName.Form.FilterO n = True

Adjusting all the names of course.

[amai]

Thank you for your quick reply. I tried your suggestion with no success. Any other suggestions?

[ssanfu]

As a continuous form cannot have a subform,

Says who? I do this a lot.

But I have never used datasheet view. I use a form in continuous form view and add controls . This way I can control placement, color, formatting, etc. that you can't do in datasheet view.

Try this. In a COPY of your database:

1) You have the main form displaying the invoices in continuous form view.
2) In the main form FOOTER (I never put a subform in the detail section), add the subform (also in continuous form view). Access might complain. Ignore it. Close the dialog box.
3) Set the main form/sub form linking fields.
4) Then check and reset (if necessary) the forms to continuous form view. <<<=== important
5) Switch to form view.

Click on different main form records. If there is a related record, it should appear in the sub form.

[pbaldy]

Thank you for your quick reply. I tried your suggestion with no success. Any other suggestions?

What exactly did you try (your code)? Where was it? What happened?

[amai]

Thank you. This worked.