Athough I am new to access I have experience using other relational databases. I need help on a project that I am working on.
I want to create a variable that will be initialized by a user selection and then be passed on to different forms.
As a test I used a list box(filled in by the table1 field ABC) and adjusted the properties so that when clicked the following;
Public sub apple_click()
XYZ=ABC <--- ABC is a field in a table
On the same form I created a text box to see the value of XYZ
I could not get this text box to display the variable value. It only had #name?.
Does anyone have a suggestion on what I am doing wrong?