Problem passing form data from synchronized list box to master table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jmartmem
    New Member
    • Feb 2008
    • 87

    Problem passing form data from synchronized list box to master table

    Greetings,

    I have a troubleshooting problem that's driving me crazy!

    I have a form [Project Initiation Checklist] with dozens of controls. One particular control -- a list box [SSPAOrg] -- is synchronized with a combo box [PIC_ContactName] such that when the user selects their name from the combo box, the name of their manager/director automatically appears in the list box.

    The problem is that when the user completes the form and submits the form data via the click of a button, the only data from the form that is NOT passed through to the master table [EZTracking_MAST ER] is the list box. When I check the master table following the completion of a form, the value for this field is null, even though I'm positive the list box contained a value that should've been saved there.

    The form worked perfectly in the beginning and only recently developed this problem. Can anyone suggest a solution?

    Regards,

    - JM
  • jmartmem
    New Member
    • Feb 2008
    • 87

    #2
    No need for anyone to reply. The problem was an incorrect setting in my control properties. It's corrected and works fine now.

    - JM

    Comment

    Working...