Link and autofill a name based on NumberID

[Kassy]

I have a main form for a tblCommittee and a subForm 'sfCommitteeOfficer' that will eventually take an entry or show -if its existing, a list of Committee officials. The officials come from a 'tblMembers'. There are too many members to use a drop down list box to select the MembNumber. What I wanted to do was be able to enter the MemberNumber in a txtBox 'MembID' on the form in the row containing Memb#, MembName, Position i.e chairman, Date elected Date retired, and have the members name automaticlly entered into the field MembName of the subform to limit the amount of entering the user has to do!
Is this possible? I have a tblCommiteeType with key field CommitteeID, and foreign Key MembId, so I dont think I need a tblCommitteeMember because names are already stored in tblMembers.

 

[RuralGuy]

Maybe you will find this link useful. Combos with Tens of Thousands of Records

 

[Kassy]

Combos with thousands of records.

Have downloaded the article will read and try to apply it -thanks.

 

[RuralGuy]

Hi Kassy,
Post back if you need addition assistance. Always glad to help.