Chronological order on Form

[zbird]

Hi,

It might be fairly obvious, but I can't get my head around this.

I have just created a Contact History for our contacts (phone call, letter etc.) with members. We had contacts with them in the past and I would like to record those, but in the meantime we have contacts with them day by day, too. I also would like to record these. I have problem bringing up the dates in the right order on the form.

Unfortunately, when I open the Form each time, I need to click on 'Sort Ascending' to get the right chronological order for each contacts on the Members form. If I do this in the TABLE, I can keep the chronological order permanent, while doing this on the form it doesn't seem to be possible to avoid to 'Sort' them each time when I open the form. The problem is, that I have created a Contact History ID, to gain an individual code for each contact (outgoing email, letter etc.) and Access priorities the contact history according to the ID number, not the date.

Is anybody can help me to figure out a more efficient way to see the right chronological order on the form?

Many thanks,
Susanna

 

[gemma-the-husky]

two ideas


1. base your form on a QUERY, with contact/contact history joined together, sorted in contactid AND contactdate order

have a form/subform


2.
form, based on the contacts themselves
subform based on the contact history

as you navigate through the contsacts on the form, you will see the history for each contact.

 

[zbird]

Thanks, I will try the first idea, as I haven't tried that yet.
About the second point: I have created the Contact form and the Contact history as a subform in a tab along with other subforms, but it doesn't keep the chronological order as I tab through the contacts. I based them on the table, not on query, though.
If I make a query based form instead of the one that I have already done, will I be able to transfer all formal issues that I have worked on before? Like colours and field layout? Or I need to build the form from scratch again?

Thank you very much for your help.

 

[gemma-the-husky]

you HAVE to use a query, based on the table, and you sort the query anyway you want, and include exclude rows based no other criteria

then just change your forms record source to use the query instead of the form.

5 minutes work, at most.

 

[zbird]

I have done it! Thank you. It works very well!