Re: Sorting subforms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Jeff,

That's done the trick though it seems a bit of a complicated way of going
around things. I guess that's just one of many quirks of Access which I am
learning about.

Thanks for the help.

ChrisK

"Jeff Boyce" <nonsense@xxxxxxxxxxxx> wrote in message
news:%23FhG8k0UGHA.1160@xxxxxxxxxxxxxxxxxxxxxxx
Chris

Go to the form you are using as the sub(?sub)form. Open it in design
mode.
Take a look at what you're using as a source. If it isn't a query, based
on
the underlying table, make it a query, based on the underlying table.
Sort
the query.

Your sub(?sub)form should now show (sorted) data.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"ChrisK" <chris@xxxxxxxxxxxxxxxxxxx> wrote in message
news:6LxWf.13310$Ph2.7351@xxxxxxxxxxxxxxxxxxxxxxx
I am a complete beginner at using Access and have been setting up a
database
for keeping details of customers, machines and jobs. I have managed to
get
it looking something like I want but have now got stuck so hope someone
can
help me.

I have a main form contaning customer contact details. In this is a
subform
with machines which the customer has on site and within that is another
subform (in continuous form view) where I enter details of jobs carried
out
on each machine. This works well in that when I select a customer I see
only
the machines which that particular customer has and selecting a machine
then
shows me jobs recently carried out as well as letting me enter a new
job.
However I can't get this sorted by date and it seems to be quire random
in
order.
If I set the property of subform to Order By date then when main form is
opened I get error saying "You must use the same number of fields when
you
set the LinkChildFields and LinkMasterFields properties".
If, instead of having the Record Source as the related table, I use the
Query Bbuilder to select and sort by date field, I get listed in the
subform
all jobs not just those related to the selected customer and machine.

I hope that I have made it clear what I am trying to do and would
appreciate
any help or advice.

ChrisK






.

Relevant Pages

  • Re: Sorting subforms
    ... machines and jobs. ... I have a main form contaning customer contact details. ... subform where I enter details of jobs carried ...
    (microsoft.public.access.forms)
  • Sorting subforms
    ... machines and jobs. ... I have a main form contaning customer contact details. ... subform where I enter details of jobs carried out ...
    (microsoft.public.access.forms)
  • RE: Subform2 change with record select on subform1
    ... Customers, then Contacts tab, Notes tab, Calls tab, and Machine/Service tab. ... The 1st for Machines the customer ... The Record Source for the Machines subform is: ...
    (microsoft.public.access.forms)
  • Subform2 change with record select on subform1
    ... that lists all machines owned by a customer, and subform 2 that lists all ... service done on the machines owened by that customer. ... Subform 1 is a continuos form showing each machine with model, serial#, date ...
    (microsoft.public.access.forms)
  • Re: Trouble getting a where command to work
    ... the customer information in the Jobs table. ... Customer table) with a subform. ...
    (microsoft.public.access.forms)