I need to populate a sub-form field from the original form

M

Michael

I can't see how to do this. I want to be able to be in form1 and then if I
need to use sub-form1, I want to be able to click on the sub-form button and
the Primary field be autofilled from form1. For instance, Member ID is the
primary key in form1. When I open sub-form1, I want the Member ID to
populate in the sub-form.
 
J

John W. Vinson

I can't see how to do this. I want to be able to be in form1 and then if I
need to use sub-form1, I want to be able to click on the sub-form button and
the Primary field be autofilled from form1. For instance, Member ID is the
primary key in form1. When I open sub-form1, I want the Member ID to
populate in the sub-form.

If it's actually a Subform (a Form displayed within a Subform Control box on
the mainform, with MemberID as the master/child link field) then no button and
no code is needed.

Popping up a separate form can certainly be done, but it takes some code; do
you want to create a new record with this MemberID, or display an existing
record with this MemberID, or what? More details please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top