Show only the last record when previewing a report

F

FollanA

Hi All,

I am half way to the answer on this put can't work out the last part.
I have a form which is used to insert data into a table, when I click the
insert button the table is updated and then a report is opened to dislpay the
data. Problem is the report displays all the records.

What I need it to do is only display the record that was just entered.

I have tried using the gotorecord function but Access tells me I can't use
this in preview mode.

Any ideas?

Cheers,
Andrew
 
F

FollanA

Hi Duane,

Thanks for the reply.

I have been trying this but I think the problem is my form is set to Data
Entry as I don't want any previous records to be displayed when opened.

Once I click the command button the tabel is updated but the form is cleared
so I don't think the ID value is being retained before the next part of the
VB is being run (does that make sense)?

How would I prevent the data from being "lost" before the below VB runs?

Cheers,
Andrew
 
P

PC Datasheet

Base your report on a query based on the table rather than basing your
report on the table. Include the primary key in your query. Put the
following expression in the criteria of the primary key field:
Forms!NameOfYourForm!NameOfThe PrimaryKey
 
M

Marshall Barton

FollanA said:
I am half way to the answer on this put can't work out the last part.
I have a form which is used to insert data into a table, when I click the
insert button the table is updated and then a report is opened to dislpay the
data. Problem is the report displays all the records.

What I need it to do is only display the record that was just entered.
Click to expand...


Use the OpenReport method's WhereCondition argument to
filter the report's data.

Modify your code to include something like:

stWhere = "keyfield =" & Me.keyfield
DoCmd.Openreport "reportname", acViewPreview, , stWhere
 
F

FollanA

Hi Marshall,

I have done exactly that but the problem I have now is that keyfiled always
equals null, resulting in an error.

Andrew
 
F

FollanA

Ok, I have worked out I can get around this by adding a goto last record step
after the insert step, this just brings back the record into the field.

Thanks for everyones help.

Cheers,
Andrew
 
M

Marshall Barton

I might be able to make more specific suggestions if I could
see the code that you're using, but why not just save the
record's key field before saving the record? Then you
wouldn't have to mess with the form's normal activities.
 
Top