Results 1 to 2 of 2
  1. #1
    djclinton15 is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    123

    How to bound 2-controls n a Form?

    Hi. I created a Form with several fields (or controls), which are already pre-Conditional Formatted. My purpose in creating this Form is because I use (copied/paste) these pre-Conditional Formatted controls in other Forms. It saves time & errors from having to repeated pre-Conditional Formatted the same controls in different Forms I'll attempt to give an I.E., I have a control named, 'Mnths' & I have each 'Mnth' having a different background color (using pre-Conditional Formatting). Likewise with 'WkDys' controls & other controls.




    Now, here's my question, I find that some of my controls are not connected (or bound might be the correct term) with the adjacent text box related the control. When I want to copy/paste (click on) on some controls the adjacent text box is also connected/bound. While, when I have other controls when the adjacent text box is disconnected/unbound & I need to click on both the field & the adjacent text box. Therefore, is there a way & how can I go about connecting/bound those controls to the
    adjacent one/or several fields?


    Any advise/suggestions will be greatly appreciated! Thanks in advanced.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Many controls, like a TextBox Control, have a property called, "Control Source". If you leave this property blank, you will have an unbound control. Alternatively, you can put something in the control source. The easiest way to bind a control is to, first, bind the form to a table or a query via the form's recordsource. Then, select an available option from within the Control Source property of your control.

    I would start by double checking the name and control source of any control you paste onto a form while in design view of your form.

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

Similar Threads

  1. Replies: 6
    Last Post: 01-30-2014, 05:57 PM
  2. Bound Controls?
    By dccjr in forum Programming
    Replies: 3
    Last Post: 04-24-2013, 08:05 PM
  3. Bound form with bound combobox
    By Jerry8989 in forum Access
    Replies: 2
    Last Post: 12-05-2011, 01:50 PM
  4. Replies: 0
    Last Post: 05-09-2010, 08:43 AM
  5. Bound controls "mis"behaving
    By DanW in forum Forms
    Replies: 3
    Last Post: 11-16-2009, 11:35 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