display last record in a subform

[gymphil]

I want to permanently display the previous record in a subform. But whenever
I go to add a new record on the main form the subform data goes! I have had a
response for this but the websit page does not load. Any help would be
appreciated.

 

[Arvin Meyer [MVP]]

A subform is supposed to contain the many-side records of a main form, or in
some cases a related 1 to 1 record. In any case it is always a related
record. Therefore it is impossible to have any records which are related to
a new record. If you do, there is something drastically wrong with your
database design.

 

[gymphil]

Arvin,

Thank you for your response.

I am not trying to relate the record on the main form and subform, the
intention is to display the previous record in the subform. This is an
inventory database and I want the user to be able to see the last
transaction, or is there another way of achieving the same result?

 

[Arvin Meyer [MVP]]

What is the recordsource of the main form, and the recordsource of the
subform?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[gymphil]

Arvin,

I have sorted it!

The main forms record source is a combo box, the subforms record source was
a queiry that was based on the same combo box. I have now changed the query
to dlookup the previous record in the table and have removed the links on the
subform.

It now works a treat. the I have both the new record and previous record
displayed on the same screen!

I appreciate your help on this one, it has been a challenge!