Subform Question

[Guest]

I had help from Ken Snell to test a subform connected to a form which I will use to create additional records for my database. His help was good

Now since that works, is there a way I can use this subform by itself in the switchboard menu so that a person could enter the "Policy Number" which is the primary key to bring up the form and prefill date to the form based off the policy number such as the subform on the form does?

Is the best way to create one visable field the 'Policy Number" and then use the subform I want.?

Any ideas and does this make sense?

The initial form with the subform is based on a query.

 

[Larry Linson]

Instead of using the subform in your switchboard, consider using a ComboBox
with the Policy Number (and record ID if it is separate) in the query you
use for Row Source. In the AfterUpdate event of the ComboBox, use the
selected Policy Number or record ID to construct either the WhereCondition
argument of a DoCmd.OpenForm or the whole SQL statement for the Form.

Larry Linson
Microsoft Access MVP

I had help from Ken Snell to test a subform connected to a form which I

will use to create additional records for my database. His help was good

Now since that works, is there a way I can use this subform by itself in

the switchboard menu so that a person could enter the "Policy Number" which
is the primary key to bring up the form and prefill date to the form based
off the policy number such as the subform on the form does?

 

[Guest]

Larry I am a little slow so bear with me.

Obviously I need to create a form. I am confused about which query to use. One I already have? There could be more than 3000 choices for policy number!

Can you explain in more detail how to construct what you said?

 

[Guest]

Issue Resolved by use of subforms and input form off of macro