List text in textbox

[KevCB226]

Hi

Quick question, how would you advise I do the following.

I have a form with an unbound textbox.

What I would like to do is create some sort of log in a textbox with the newest listed at the top.

I have a table with this information in that contains an ID, a memo field which lists the details, and a date field.

I would like to list all the details based on an ID, and with the newest details being the first listed.

How would I go about doing this?

Thanks

 

[neileg]

A subform would be the easiest based on a query with the ID as a parameter. Sort the query in descending date order.

I have no idea what your unbound textbox is for, though. Can you explain?

 

[KevCB226]

I don't think I made it clear in the previous post. So I'll have another go

I would like to have a log of comments with the newest being listed first.

The comments are in a seperate table along with the date the comment was added, and the ID it relates to.

The unbound textbox is what will act as the log, and list the comments.

The problem will be getting the comments listed in the unbound textbox.
I have decided to do it this way because to save searching through records looking for the most recent comments, so I could list the more recent comments at the top to save searching through the records.

 

[neileg]

You need a continuous form, not a text box. I assume you are going to identify the ID that you are interested in from a combo box. This combo will give you the parameter to pass to the query. The log that you are looking for will be based on the query, either in the detail section of the form or a subform, depending on what you are wanting to display in addition to the log.

 

[KevCB226]

Thanks, but how do I get the form working?

I have created a continuous form based on a query, which I have added a parameter for the ID that looks for the same ID on another form that's open in the background. And the date is sorted in descending order.

That's as far as I got, so how do I now set up the form to list the comments?