display last record in a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gymphil - 24 May 2008 09:05 GMT

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.

Reply to this Message

Arvin Meyer [MVP] - 24 May 2008 17:55 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>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.

Reply to this Message

gymphil - 24 May 2008 18:28 GMT

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?

> 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
[quoted text clipped - 7 lines]
> > response for this but the websit page does not load. Any help would be
> > appreciated.

Reply to this Message

Arvin Meyer [MVP] - 24 May 2008 19:35 GMT

What is the recordsource of the main form, and the recordsource of the
subform?

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Arvin,
>
[quoted text clipped - 18 lines]
>> > response for this but the websit page does not load. Any help would be
>> > appreciated.

Reply to this Message

gymphil - 25 May 2008 11:20 GMT

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!

> What is the recordsource of the main form, and the recordsource of the
> subform?
[quoted text clipped - 20 lines]
> >> > response for this but the websit page does not load. Any help would be
> >> > appreciated.

Reply to this Message