Subform not showing correct data

P

P

I have a form with two levels of subform on it, reflecting the hierarchy of
tables;

Customer - Primary index is serno, contains details about the customer

ContactLine - Primary index is contactlineid, has foreign key to Customer.
Contains details about an individual transaction

ItemLine - Primary index is itemlineid, has foreign key to Contactline.
Contains details about the items in an individual transaction


My form shows Customer details, with a subform showing the contactline
transactions for that customer. The Contactline form has a subform showing
itemlines.

Customer and ContactLine seem to work well. When I press the button which
exists on the ContactLine to create a new ItemLine, it updates the ItemLine
table correctly, but the data shown in the Itemline subform is the data for
the previous Contactline. If I move off that ContactLine record and then
back on, the Itemline subform then shows the correct data.

I've been playing all day on this, with no success. Has anybody seen this
problem? I've tried adding Requery commands in various places (AfterUpdate
on the ContactLine, for example), but with no success.

Regards,

Pete.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top