Subforms displaying information

R

Richard

Hello,

I have two tables (tblStockLoan & tblStockReturn). I have
based two forms (frmStockLoan & frmSubStockReturn) off
these two tables.

Records are linked when they have the same "Orig Number"
in the two tables.

As you scroll through the records in frmStockLoan the
corresponding tblStockReturn record should be displayed in
the frmSubStockReturn, which is located within
frmStockLoan.

I have just used the simple Subform wizard to get this far
and it seems to work okay.

The problem is if I close out of the db and go back in,
when I scroll to a record which I know has a corresponding
subform record the subform record does not appear....

Strange thing is, if I click into the design of the main
form, then straight back to display mode the subform
record will appear....

Weird!! I know, I have asked about 4 people around here
and nobody has a clue, I think it may have something to do
with my subform not refreshing correctly.

if you have any ideas, I am all ears.

Please advise,
Regards Richard.
 

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

Similar Threads

DLookup in Continuous form 0
Split form 0
Populate main form from subform record 0
VBA code returns no records hwenKey ID is added 14
Problem refreshing subform 2
Stop subform from scrolling to new record line 5
How to position records in a scrolling subform 5
Continues Subforms Scrolling 2

Top