Results 1 to 2 of 2
  1. #1
    jhjarvie is offline Novice
    Windows Vista Access 2003
    Join Date
    Sep 2008
    Posts
    12

    populate the same named field in two subforms??

    OK I will try and explain as easy as I can....



    I have an Access form (Frm_Main) which includes two sub-forms (frm_Contracts and Frm_Repairs)

    Both sub forms have a field within them called 'Frequency' which have combo boxes to enable the user to chose from a set list of values.

    What I would like to do is this.....if I choose a value in the subform frm_Contracts!Frequency i.e. "6 Months", when I go to choose a value in frm_Repairs!Frequency the drop down should only allow me to choose the same value "6 Months" to populate the field, therefore both fields have always the same value.

    Make any sense?

    Any ideas?

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    What you need to do is to bind the send control to the first combo. Then change the second combo to a text box as the user cannot make a different selection. The only issue you may have is that the functionality fails if you want it to work both ways. In reality it shouldn't.

    David

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Saving unbound feild values
    By John Saul in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:22 AM
  2. Auto Populated Field not Saving to Table
    By EstesExpress in forum Forms
    Replies: 4
    Last Post: 10-09-2009, 03:33 AM
  3. Access 2000 Auto Populated Fields
    By Cylena in forum Access
    Replies: 1
    Last Post: 05-18-2009, 07:50 AM
  4. Replies: 1
    Last Post: 03-02-2009, 10:12 PM
  5. CallTicketID populated to Order Form
    By EisBlade in forum Forms
    Replies: 0
    Last Post: 04-03-2006, 10:50 AM

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