From Not working - LOST!!!

[RitaMoloney]

Hi,

I have three tables called
tblParishioners
tblYears
tblCollection

I am trying to make a form so that when you select a parishioners name, it will find the record (years, collections made) associated with that person which is/or closest too the present year.

I have attached two forms:
frmParDetails and frmCasCombo.
tblParishioners and tblYears are made up of the main form
tblCollection is made up of the subform.

On frmParDetails, I have a combo box that will find a record by selecting a person’s name, which is working.
Problems are:
How do I get the YearPeriod field to default to the most present year.
I wanted to have a combo box with a list of the years associated with the person selected so that if the user selected a previous year the subform will show details for the collections for that year.

In the form frmCasCombo, I have tried to make two cascading combo boxes, which are working.
Problems are:
When you select a person name it will not fine the person’s details.
How do you make the second combo box (Years) always display the most present year.
Since the second combo box is unbound how do you get the subform to display the box.

I really, really need help with this and am not sure what is the best way on how to go about doing it. Any help would be really appreciated.

Thanks in advance,

 

[RitaMoloney]

No suggestions......ideas??????

 

[Russyfoot]

Try this

Hi Rita

Use the help facility. Enter "select highest" then click on "customize list boxes..etc" There's a bit in there about changing the sort order which may acheive what you want.

HTH