Refreshing a form in Access MDB

[SupernovaKarl]

I have a form (holding membership details of nthe members of a club) that
does some calculations of figures elsewhere in the database. When this
information changes for some reason (eg a member changes his class of
membership and the membership fee changes) the form isn't updated with the
new result until the it is closed and reopened. However, when the form
reopens, it does so at record number 1and it is necessary then to use FIND to
get back to the form I was working on This seems awkward and
unsatisfactorily and I expect it ca be got round easily using VBA code, which
I haven't mastered yet. Any suggestions ?(other than "get down to it and
learn VBA" !!)

 

[Jeff Boyce]

Add an unbound combobox in the header of the form. Make the row source of
the combobox a query that returns a list of members.

Make the form's control source another query that returns all the data on
the form, but only for the member identified in the combobox.

In the combobox's AfterUpdate event, add something like:
Me.Requery

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[SupernovaKarl]

Many thanks Jeff. That sorted it.

Add an unbound combobox in the header of the form. Make the row source of
the combobox a query that returns a list of members.

Make the form's control source another query that returns all the data on
the form, but only for the member identified in the combobox.

In the combobox's AfterUpdate event, add something like:
Me.Requery

Regards

Jeff Boyce
Microsoft Office/Access MVP