Update form with record from subform

T

Trev

I have a membership database that has a member form with
a membership details subform on it. The sub form has Date
& Membership Level fields
I need to display the Membership Level from the last
record from the linked membership details subform in a
field on the member form.
I am trying to use this to maintain a membership history;
Would it be possible to return this value for the current
membership year and possibly return "Non Financial
Member" if the membership is not current?
If there is a better way to do this I would appreciate
any suggestions.


Regards
 

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

Similar Threads

2-field prmary key into Foreignkey 3
Ordering records in form view 2
Can "like" function be used with combo box? 3
User Interface to select Individual or Company Donors 3
How to Navigate Through Records in Alphabetical Order 2
One main form to update several tables? 3
linking data in subform to main form 2
Accessing fields on Record Source without putting them on form/subform 4

Top