Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Ahsan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    15

    it fills the data in the subform. I JUST WANT TO LIMIT THE CITY COMBO IN SUBFORM BASED ON THE USERNAME COMBO.

  2. #17
    Ahsan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    15
    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.

  3. #18
    Ahsan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    15
    it just fills out the subform. i just want to limit that city combo box based on the uername combo box.

  4. #19
    Nod_Swerdna is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2015
    Posts
    27
    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.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-14-2015, 12:00 PM
  2. Replies: 4
    Last Post: 12-22-2014, 11:07 AM
  3. Replies: 9
    Last Post: 10-09-2013, 08:45 AM
  4. login form and filter to specific record
    By mikael in forum Programming
    Replies: 1
    Last Post: 04-10-2013, 12:02 PM
  5. Replies: 3
    Last Post: 05-28-2011, 09:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums