Binding a text control to a database in design-view

  • Thread starter Thread starter kyote
  • Start date Start date
K

kyote

I've designed several tables and now I'm trying to create a form for
inputting data into the tables DB. But I'm having some trouble.

I want to create the form or forms in design view not with the wizard
but it's giving me trouble

1) click the text box
2) click on properties
3) click data tab
4) click the 3 dots(...) at the end of Control Source
5) double click on 'tables' in the far left pane(of 3)
6) click on 'customer' in the far left pane whichs drops down from
'tables'
7) I then double click on FirstName in the middle pane since if I
single click it nothing happens(meaning there is nothing in the
'values'(far right) pane. And if I single click it and then click on
paste or double click it it puts this into the main builder area

[Customer]![FirstName]

Then when I go into form view and try it out it autofills this

#Name?

And it won't let me change the values in the text boxes. In fact it
says

control can't be edited; it's bound to an unknown field



What am I doing wrong?
 
1) click the text box
2) click on properties
3) click data tab
4) click the 3 dots(...) at the end of Control Source
5) double click on 'tables' in the far left pane(of 3)
6) click on 'customer' in the far left pane whichs drops down from
'tables'
Click to expand...

You're going about this incorrectly.

A Form is based on a Table, or (very commonly) on a Query based on a
table or perhaps two tables.

The fields *within that table or query* are those which are available
for binding to controls on that Form.

Often if you have two tables in a one to many relationship you'll use
a Form of the "one" and a Subform for the "many", or even three or
four subforms, side by side or nested.

But you can't just pick a field from this table and another field from
that table and use them as control sources!
 
You're going about this incorrectly.
Click to expand...

Please, could you tell me how to go about it properly? Or even point
me to a website that can?
A Form is based on a Table, or (very commonly) on a Query based on a
table or perhaps two tables.

The fields *within that table or query* are those which are available
for binding to controls on that Form.
Click to expand...

Isn't that what I'm doing? Making some tables that have relationships
to each other and then trying to create a form with a control that is
bound to 1 or more fields on those same tables?
Often if you have two tables in a one to many relationship you'll use
a Form of the "one" and a Subform for the "many", or even three or
four subforms, side by side or nested.
Click to expand...

I am currently trying to make a form to connect to a table with a one
to many relationship.
But you can't just pick a field from this table and another field from
that table and use them as control sources!
Click to expand...

Why not Mate? Could you explain a little please?
 
Please, could you tell me how to go about it properly? Or even point
me to a website that can?


Isn't that what I'm doing? Making some tables that have relationships
to each other and then trying to create a form with a control that is
bound to 1 or more fields on those same tables?
Click to expand...

You're apparently starting with the Controls. Instead, start with the
Form's Recordsource.
I am currently trying to make a form to connect to a table with a one
to many relationship.
Click to expand...

Then use the "one" side table as the Recordsource for the main form;
the toolbar contains a "field list" tool which will present you with
all the fields within that table, which can be put onto the form
wherever you like. Base a Subform (another form, which can be created
separately and dragged onto the mainform, or can be built in place
using the Subform tool on the toolbar) on the "many" side table, using
the Primary Key of the "one" table as the Master Link Field and the
matching foreign key as the Child Link Field.
Why not Mate? Could you explain a little please?
Click to expand...

Well, it's getting late... Check out some of the many good books, or
the references available at http://www.mvps.org/access.
 
Back
Top