have two subforms, make first subform more user friendly?

[RitaMoloney]

Hi,

I have a main form and two subforms (in datasheet view).
On the main form (frmPar), I select a persons name which finds the records for that person on the two subforms. The first subform(frmsParYr) shows a list of years, depending on the record selected, the second subform (frmsParCol) shows the details for that year. (On the first subform there is some code to always select the last record, this will always bring up the record nearest to the present year).

I want to make the first subfrom (frmsParYr) more user friendly. Is it possible to change it to display the years in a combo box/list box. So that, the user can move through records by selecting the different years?

I have attached the form.

Thanks in advance for you help/suggestions/ideas.

Rita

 

[SelfTaught]

Hi,

this is pretty easy to do, first you have to isolate the tblYears, (remove the relationships) and convert the Year Period column to a look-up column, and then on the form change the feild to a combo box, and have its rowsource the column with the data in it. Its actuly very simple to do, as long as you know how. This is all done with the properties window.

I have done a very basic sample for you (I hope i attached it to this msg properly)

Lisa

 

[RitaMoloney]

Hi Lisa,

Thank you for your response.

I tried your suggestions but it does not solve the problem.
The combo box produces a list of all records (years) regardless of the persons name I have selected.
It also does not allow you to move through the records by selecting a year.

Rita