Is it possible to populate more than one field from a Combo Box

[mick3911]

I am in the process of making a membership DB for my sports club and I have a question as per the title which I hope you guys 'n girls can help me with.

Members pay subs twice a year (Summer & Winter seasons).

I have a table with members details and a table with subscription details (different subs for different types of members).

On the members form I would like to display the 2 subscriptions that relate to that member. At the moment I can only display one.

I have no experience of VBA and I have forgotten more than I have learnt with Access so please be gentle with your replies

Cheers Mick

[pbaldy]

Is this what you're after?

BaldyWeb - Autofill

I'd be interested in the table layout, as it sounds like you may not have a normalized structure.

Fundamentals of Relational Database Design -- r937.com