use hyperlink to open form based on value in the field

[tagteam]

I have a continuous form that lists all unapproved invoices. I would like to have a hyperlink at the end of each row that says Review and will open another form that queries the details of the unapproved invoice based on the invoice number in the current row.


Thanks for any help

[June7]

AFAIK, that's just a DoCmd.OpenForm code in textbox Click event. The textbox can be formatted to appear as hyperlink with the DisplayAsHyperlink property.

DoCmd.OpenForm "formName", , , "ID=" & Me.ID

[tagteam]

The form will be based on a query and I need to pass the value of the Invoice Number of the row I am clicking so the form only opens the Invoice Detail rows from the invoice number I clicked on. I dont just need to open the form, Basically I need to open the form and say find invoice detail records with this invoice number.

[June7]

The example code will open form filtered to only record(s) that meet the given criteria. I used generic ID as example. Use invoice number if you want.

[tagteam]

I tried this and it is not working

DoCmd.OpenQuery("q_UnapprovedInvoices", , , "InvoiceNumber=" & Me.InvoiceNumber)

[tagteam]

DoCmd.OpenQuery "q_UnapprovedInvoices", , , "InvoiceNumber=" & Me.InvoiceNumber
Says
Compile Error: Wrong number of arguments or invalid property assignment

[June7]

My code is to open form, not a query.

[tagteam]

ok, I changed it to a form

DoCmd.OpenForm "f_ApproveInvoice", , , "InvoiceNumber=" & Me.InvoiceNumber

And get - Run-Time error 3464 - Data Type mismatch in criteria expression

If I try to do it in the macro builder and put InvoiceNumber=Me.InvoiceNumber in the Where section it pops up the dialogue box and asks you to enter the invoice number and then it works.

So that is closer but i am not sure if I did the where clause correct in the macro builder

[June7]

Is InvoiceNumber a text type field? Need apostrophe delimiters.

"InvoiceNumber='" & Me.InvoiceNumber & "'"

Date/time fields use # delimiter, number fields do not have delimiter.

[tagteam]

Yes, Invoice number is a text type field.

I have used
DoCmd.OpenForm "f_ApproveInvoice", , , "InvoiceNumber=" & Me.InvoiceNumber & ""

And it still gives me the data type mismatch error

Then I realized that you had typed it different

DoCmd.OpenForm "f_ApproveInvoice", , , "InvoiceNumber='" & Me.InvoiceNumber & "'"

This one has a single quote (Apostrophe) before the quote after the = sign and a single quote (Apostrophe) between two end quotes. (added in case someone else sees this post.

It is working now.
Thanks