Multiple source tables on one form

  • Thread starter Thread starter DAL
  • Start date Start date
D

DAL

Hello.

I'm setting up my first Access database and have come
across a problem I can't seem to answer with online
HELP. I'm dragging textbox fields onto a single form
from different source tables. When I attempt to enter
information into the form (which should insert values
into the respective underlying tables), the status area
displays "Control can't be edited; it is unbound." When
I check the properties for the text box, the control
source seems to be correct, but when I select the drop-
down list from which to pick the source, field names are
displayed from a different table and I cannot change the
source table.

Any help is appreciated.

DAL
 
It's not clear how you managed to add controls to the form that are bound to
fields that are not in the Record Source. Open the form in Design view and
open the Field list. If you don't see the field in that list, then you'll
have to change the Record Source. Select the form and open the Properties
window. Select the Record Source property and click the Build button (...)
next to the property to open a query on the Record Source. Be sure that all
tables that you need are in the Record Source and that the fields from those
tables are output by the query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
A form can only have a single record source. If your tables are related,
create a query that joins the tables appropriately, and use the query as the
record source.
 
Back
Top