click on record into report view

[smahdih]

dorod (means Hi)



i have a report like below picture, i want be able click on a record in report view and then open a form with additional fiels according to current record.

in other word i want when user click on record into report view opens a form and user can change OrderStatus

how do this?

[pbaldy]

You can do this from report view

http://www.baldyweb.com/wherecondition.htm

[smahdih]

You can do this from report view

http://www.baldyweb.com/wherecondition.htm

i do this but when click on record into report, a form without record shows.

i relate a field in report with primary key field in form

[pbaldy]

The form isn't in data entry mode, is it?

[smahdih]

The form isn't in data entry mode, is it?

data entry set to No, but when change it to yes not influence in form

[pbaldy]

You want it on No. What is your exact code? Can you post the db here?

[dustmopheadmop]

Marahaba means “Hi”
My dear, report is something that could be presented on screens and on printers. And it has some limited events to serve it purpose.
I mean to say you can’t open a form depending on clicking on record that displayed on a report.
To solve this problem, you may use form instead of report, let user click on record and then display your other form on screen.

I hope it help.

[smahdih]

You want it on No. What is your exact code? Can you post the db here?

i want when click on orderCode into rptQryPending open frmKhahInbox by filter OrderCode

[pbaldy]

I mean to say you can’t open a form depending on clicking on record that displayed on a report.

This is not accurate with the new Report view available beginning with 2007. It is interactive.

Smahdih, instead of this:

DoCmd.OpenForm "frmKhahInbox", , , " Text47 = '" & Me.OrderCode & "'"

You want this:

DoCmd.OpenForm "frmKhahInbox", , , "OrderCode = '" & Me.OrderCode & "'"

You also want to take the criteria out of the form's record source.

[dustmopheadmop]

Hi,
The attached db you have post previously is an old version of MS. Access, its extension says .mdb, and this to the people who says that it is an interactive report with new MS. Access version.
Other thing is that your Text47 that used as a link criterion is unbound to the behind record source of your form.

[smahdih]

Friends Tnx alot for Ur help

I do it and worked

Sepasgozar ( means Tnx)

[pbaldy]

Happy to help.