Showing a Value on a Modal

[2410Davie]

Hi everyone, I am getting on well with my new database and have built the login Modal which all works and now I have a Menu Modal that then opens my Properties form on a Modal but none of the values in the table show in the text boxes? I have the control source selected as the table value to show but nothing shows?

Davie

[2410Davie]

Sorry i mean when i click the button on the menu Modal it opens a PopUp form for Properties but no values show.

[ssanfu]

Would need to see your dB. Care to post it?

[2410Davie]

is there not a simple way of showing a value from a table in a text box on a Modal/Popup?

I have the standard in control source = =[Properties]![Hook Number]

[ssanfu]

You cannot refer directly to a field in a table. (=[Properties]![Hook Number])

- You can "Pull" a value from one form to another (=Forms!FormName.ControlName)
- You can "Push" a value from one form to another
- You can use "OpenArgs" with code to get a value from one form to another
- You can write a UDF to get a value from a table.
- You could use the "DLookup()" function


FYI, "Properties" is a reserved word in Access and shouldn't be used as object names.