We help IT Professionals succeed at work.

How do I bind a table in Access 2013 to a form

BLACK THANOS
BLACK THANOS asked
on
1,984 Views
Last Modified: 2018-02-02
Good evening Experts,

It has been a few years since I have dabbled in access databases and forms  used as front ends. What I am trying to do is to populate fields on the form from a drop down menu. I will show you an example below to show you what I am attempting.

Here is the form view:
!Here is the design view
!
As you can see I have a table  but it is not completely linked to the form. I know that I should have created the table then highlighted it to create an automatic form , but I didn't do it that way. I put the egg before the chicken so to speak, meaning that I created the form from scratch based upon a word document: see picture below:

!
From the form I am attempting to populate the address, city, state and zip fields from the drop down menu that has all of the contract numbers (unique). However when I try to choose a contract from the drop down menu it gives the following error:

Control cant be edited. It is bound to the expression  [tsgCustomerTbl]![CustomerName]

I thought that I had bound the table to the form when I formated the properties sheet as follows the appropriate control source, row source and row source type

!
!
!
!
You will notice I tried to bind customer name:


!
!
!

So now you know as much as I do. I am hoping someone can help me find a way  to help me achieve  the population of the aforementioned fields from the table to the form.
Thank you in advance for your support.

Regards,
BlackThanos
Comment
Watch Question

John TsioumprisIT Supervisor
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
BLACK THANOSSemi - Retired

Author

Commented:
Hi John,
I know I am over complicating things , but dont really want to start over. Is it possible with what I have now to , as you say, " Just set the Record Source of the form to the Table you want..." I clicked on the details of the form itself and found  the  property to set the Record Source, but it doesn't accomplish what I want , and that is to use a drop down menu to bring of records and not  the  previous and next records.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
BLACK THANOSSemi - Retired

Author

Commented:
Thank you all for your input.