Open specific record from subform

[tfaisal]

Hello
There is form in attached database 'permits in progress' i wat to click REF# that is already hyperlinked and it should open order form on a specific form.I have applied same technique by macro on several forms and it works fine but couldnt figure out with this specific form.when i click the REF# it creates a new record in table .
Please help me fix it
Attached is database

 

[CJ_London]

I don't use macros, almost impossible to debug, but your looks straightforward enough and does not look wrong to me.

So take a look at the recordsource for the OrderFinal form. You join the order table to the Axle table, but do not use any data from Axle. And your problem exists because there are no matches for orders with a status of "Active" Or "Ordered" Or "Holding", only "Permit Back".

Remove the Axle table from the OrderFinal recordsource and you will get records. Not clear to me what the intention is, but change the OrderFinal allow additions property to false and you won't get new records

I would avoid spaces and non alphanumeric characters in your field names (#,%,?) - using them can cause unexpected and misleading errors, even when 'protected' with square brackets.

Make use of relationships and standardise field names - matching REF# to OID is not something that is obvious