If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
order forms by date record created
I enter my records on a form. I also use the form to retrieve individual
records. I have a combo box to look up specific records, but sometimes I just want to flick through (using fwd/back keys) to see those most recently created. I can't seem to get them to appear in date order. I have a field 'Date received' in both the table and form and this is the field I would like to order my forms by. There's an 'order by' option in the form properties box. There's no drop-down arown, or build function next to this - what do I type in? Or is there another way to do this? |
#2
|
|||
|
|||
order forms by date record created
Create a query that sorts the data as you want it, and use the query as the
RecordSource for the form, rather than using the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Annie1904" wrote in message ... I enter my records on a form. I also use the form to retrieve individual records. I have a combo box to look up specific records, but sometimes I just want to flick through (using fwd/back keys) to see those most recently created. I can't seem to get them to appear in date order. I have a field 'Date received' in both the table and form and this is the field I would like to order my forms by. There's an 'order by' option in the form properties box. There's no drop-down arown, or build function next to this - what do I type in? Or is there another way to do this? |
#3
|
|||
|
|||
order forms by date record created
Thanks, Douglas, this did work. A.
"Douglas J. Steele" wrote: Create a query that sorts the data as you want it, and use the query as the RecordSource for the form, rather than using the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Annie1904" wrote in message ... I enter my records on a form. I also use the form to retrieve individual records. I have a combo box to look up specific records, but sometimes I just want to flick through (using fwd/back keys) to see those most recently created. I can't seem to get them to appear in date order. I have a field 'Date received' in both the table and form and this is the field I would like to order my forms by. There's an 'order by' option in the form properties box. There's no drop-down arown, or build function next to this - what do I type in? Or is there another way to do this? |
Thread Tools | |
Display Modes | |
|
|