Re: Sorting subforms

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)