Allow record inserts in subform

[Rose B]

I have a form and subform for entering expense header and expense details
respectively. When creating a new expense, the form opens for new record and
allows input OK of header info and then n detail lines (continuous form in
subform).

I then want to be able to open this form to allow updates at the form level
(i.e. edit existing data) and allow updates/inserts at the subform level.
When I open the form with a match on the expense ID (field that links the
form and subform) the form behaves exactly as I want it to but the subform
does not allow new detail records to be added. What am I doing wrong?

 

[Rose B]

Actually - have just checked back and note that I must have done something to
dig myself deeper as now the subform does not work when creating a new
expense! Will post back if I manage to dig myself out - otherwise any help
appreciated!

 

[Rose B]

OK - found the problem but not the solution!!

In my subform I have 4 fields where I need to get data from related tables,
depending upon information entered in the line. DLookup was not working as
the values needed to change on each line, so I changed the subform to be
based upon a query and bound the 4 fields. Seems this is now what has stopped
inserts working. One of the fields (a combo) was to use the values of 3 of
the entered firlds to go get the list for the users to select from. The other
3 were to fetch values from a table once the combo selection had been made
and then take action based upon one of them.

Any ideas for how I can resolve this?