Combo box to select records

[Jay]

I've got a form called FleetWork with a subform called WorkDetails. The form
displays details of vehicles in the fleet. The subform displays records of
work done on current vehicle displayed in the form. I've placed a combo box
in the form's header which I use to look up vehicles. Everything works fine
up to this point. The problem is that I would like to use this form to
update the "work done" in the sub form, but currently I can only use it to
look up records. Is there a way that this can be done? Any help would be
appreciated.

 

[Klatuu]

There are a lot of variables at play here.
If you are saying you can't add or edit records in the subform, then it
could be that the subform's record source query is not updatable. One way
to tell is to look at the navigation buttons. If the button used to add a
record (the one with the * on it), is disabled (greyed out), that means the
recordset can't be updated.

That can be caused by several things. Union queries are not updatable.
Totals queries are not updatable. Some queries with joined tables can't be
updated because of the nature of the join.

It could also be the subform's allow edits property is set to No.

You just have to look at these possibilities for starters.