Form with Subform showing all records

[Cosmo Monkey]

Super 7



I am referring to another question where the gentlemen was asking basically the same question here. He was adding a sub form that would not show all his records in a subform on the clients account. If you open his subform by itself and view the present information, you would find there was records in the database, but the first one did not utilize the simple subtraction within two fields. You have done but waste my time with your inability to perceive a simple question which I have posted more than once.

I want to open an add new record. I supplied the code on how the form was being opened upon my original post. On this add new record I want add a subform to view all previous records. Linq seems to have comphrended this. So if I may ask you NOT to respond to any more of my posts, I would appreciate this....

[June7]

I have determined why that user's records don't show in the form/subform arrangement and responded on that issue. It is a fairly easy fix.

If you want to provide your actual db for analysis, maybe Linq or someone will be able to determine solution. Follow instructions at bottom of my post to accomplish.

[RonL]

Super 7

......... On this add new record I want add a subform to view all previous records. Linq seems to have comphrended this. ........

So has Linq's fundamental advice - with which June agrees 100% - helped you solve the issue? Doesn't sound like it.

I want to open an add new record. I supplied the code on how the form was being opened upon my original post.

Yes, and it looks like the recordsource for the form is a single table. Is that correct?

I'm just a novice around here, but seems to me you are so intent on solving your issue with a subform, that you don't recognize that a subform is neither needed nor appropriate to accomplish what you want. Did you absorb Linq's description of the main form/subform scenario, particularly the words emphasized in red? Do you actually have a one to many relationship?

If you want simply to see the existing records as you add a new one in a form whose recordsource is a single table, investigate the split form. If that doesn't help, post back.

EDIT - Note that this is the same advice June gave you in her post #4.

-Ron