Data Entry form - Report? (1 Viewer)

[mounty76]

Hi All,

Is there anyway to make a report based on a new record just entered into a data entry form?

FYI The data entry form also has a subform with the child table in

Cheers

 

[Ranman256]

the entry form would have a button to open the report.
The report query would look on the form for the record key , say: txtID
qry: select * from table where [id]=forms!fMyForm!txtID

then the report would open on the record currently shown:
docmd.OpenReport "rRpt",acViewPreview

 

[mounty76]

I tried this but it didn't work? Not sure why but was guessing it was because it was a data entry form?

 

[bob fitz]

I tried this but it didn't work? Not sure why but was guessing it was because it was a data entry form?

Can't see why the solution offered wouldn't work.
Post a copy for us to look at.

 

[Gasman]

I tried this but it didn't work? Not sure why but was guessing it was because it was a data entry form?

By that do you mean Data Entry set to Yes?

 

[bob fitz]

Perhaps the record needs to be saved before the report is opened.
EDIT:
Something like:

If Me.Dirty = True Then

     Me.Dirty = False

End If

before the line that opens the report.

 

[mounty76]

By that do you mean Data Entry set to Yes?

Yes that is correct, sorry should have made that more clear

Think that is why it is not working

 

[mounty76]

my bad, sorry, totally rooky mistake....all good

 

[Gasman]

What did you do?
I was going to suggest switching data entry off and back on again.