Topvalue query populating textboxs on form NEED SOME CODE!!!

[Shaft]

I have made a top value query that pulls the the 5 latest audit scores a certain engineer has acheived, but now I want them to populate 5 textboxs on a continous form where the engineer in the query equals that of engineer on the form. I can pull values using the domain functions such as dlookup, dfirst etc. but not all 5 values in order.

So I have come to the conclusion that I must use some code but I don't know where to start.

 

[Shaft]

The thing is I'm using a continous form to list all the engineers there audit score to date, number of audits had and I want there last 5 audit scores listed too.

And you can't use a subform or list box on a continuous form to display these. I can retrieve a single value with a domain function but thats about it.

 

[Rich]

And you can't use a subform or list box on a continuous form to display these. I can retrieve a single value with a domain function but thats about it.

Well yes you can, you can also add a button which will open another form with the results of your top query, just link you forms by the EngineerID

 

[Shaft]

Does that mean you want there last 5 audit scores listed in one row?

Yeah thats exactly what I want

Quote:
Originally Posted by Shaft
And you can't use a subform or list box on a continuous form to display these. I can retrieve a single value with a domain function but thats about it.

Well yes you can, you can also add a button which will open another form with the results of your top query, just link you forms by the EngineerID

You can't use a subform in a continuous form I've tried Access tells you to change your form type, try it. If you try and use a list box to display the values they don't update for each record so every listbox contains the same values. I've tried both methods.

 

[Rich]

You can add a subform to a continuous form, just add it to the form footer and link by the engineerID.
It's not the best way to do what you want but it can be done

 

[Shaft]

That still doesn't acheive my objective. I got a more indepth report that opens when you double click a record I just wanted a front screen that gave you a quick overview so you could see which record you needed to look at.

 

[Rich]

Just what is your objective?