I have a form called Switchboard and on it is a subform called Hardware_Spares.
When a user double clicks on a row in the Hardware_Spares subform, another form opens called Harware_Spares_Details.
This all works fine!
The problem I've been having is that when Hardware_Spares_Details opens, it is supposed to take a value from the parent form (Hardware_Spares). It works on my laptop but when I open the database on another machine, it doesn't.
The code I am using in the Default Value property of the Hardware_Spares_Details form is:
I've been fiddling for 2 hours to try and make this work and now I'm loosing the will to live.
Your help is very much appreciated.
Many thanks
Daniel
When a user double clicks on a row in the Hardware_Spares subform, another form opens called Harware_Spares_Details.
This all works fine!
The problem I've been having is that when Hardware_Spares_Details opens, it is supposed to take a value from the parent form (Hardware_Spares). It works on my laptop but when I open the database on another machine, it doesn't.
The code I am using in the Default Value property of the Hardware_Spares_Details form is:
Code:
=[Forms]![Switchboard]![Hardware_Spares]![hardwareID]I've been fiddling for 2 hours to try and make this work and now I'm loosing the will to live.
Your help is very much appreciated.
Many thanks
Daniel
