Hyperlink in report to open form.

[dwcrockford]

Access 2013

I have designed a form for invoicing - it is set to begin a new record on open.

I have also designed a report which outlines invoices (all or outstanding).

On the report, I have given the "InvNo" a hyperlink format, and assigned an "on click" macro to it that opens the Invoice Form to the selected record. The macro code is

Where Condition: ="[InvNo]=" & [InvNo]
Data Mode: Edit
Window Mode: Dialog

The coding works with one exception. When it opens the form, it goes to "new record", and display results 2 of 2 in the bottom left of the window. If I click "back" arrow, it takes me to the hyperlinked record in the form (the one I wanted). What code am I missing in the macro to disable the "new" part of the form and go directly to the requested record. Can this be done without disabling the "new" on startup of the form when it is used by itself?

D.

Thanks

 

[Micron]

That solution was designed for an invoice number which would not present the problem you now have. The easiest solution is to remove the apostrophe, either as a user inputs the data, or after. The assumption is that Its, although not grammatically correct, would not be objectionable. This could be done with the Replace function: Replace (string1, find, replacement, [start], [count], [compare]). Start, count and compare are optional.

However, if you cannot, you are faced with a difficult situation in that a title can have more than one apostrophe. So in my mind you are looking at a function that uses some combination of Inst, Mid, Len and maybe Replace functions that builds a complicated concatenated string using ASCII codes. You would likely need this function to loop as well.
Something like
"It" & Chr(39) & "the Most Wonderful Time of the Year"
The function would have to insert the inner quotes as needed. Doing without the apostrophe in the title might not look so bad now?