it fills the data in the subform. I JUST WANT TO LIMIT THE CITY COMBO IN SUBFORM BASED ON THE USERNAME COMBO.
it fills the data in the subform. I JUST WANT TO LIMIT THE CITY COMBO IN SUBFORM BASED ON THE USERNAME COMBO.
It fills out the subform. i just want to limit the city combo box based on the username combo, to only show the specific city based on its name.
it just fills out the subform. i just want to limit that city combo box based on the uername combo box.
I'm coming late to this thread and you may already have solved it. I have struggled with the issue of moving a choice from one form to another and now I use VBAs built in TEMPVARS to move data from one form to another.
For example, If I want to move ValueA from FormA to FormB I will set a TEMPVARS Variable to hold the value of a control called ValueA from FormA and then read it into a Control when opening FormB...
In FormA VBA code I would create the TEMPVARS Variable by coding: Tempvars.ADD "MyValue", me.ValueA
In FormB 'ON LOAD' or 'ON OPEN' VBA Code I would read the value from TEMPVARS("MyValue") into a local Control as follows: Me.ValueA = TEMPVARS.MyValue.
I hope this helps and I'm not too late with this info.