Linking Data in table to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Needless to say, I am new to Access, although I had years programming DOS databases

In a form I want to display data that is in a table. In the form's Control Source I put (without quotes) "=[Clients]![IntroDate]" - where "Clients" is the name of the table and "IntroDate" is the field in the table. I get #NAME error

The above is what Access put in

Thanks

John H W
 
-----Original Message-----
Needless to say, I am new to Access, although I had years programming DOS databases.

In a form I want to display data that is in a table. In
Click to expand...
the form's Control Source I put (without quotes) "=
[Clients]![IntroDate]" - where "Clients" is the name of
the table and "IntroDate" is the field in the table. I
get #NAME error.
The above is what Access put in.

Thanks,

John H W
.
You have to select a table or query as the forms control
Click to expand...
source, then add text boxes which reference fields from
the table or query. In the forms propery page you should
be able to select a table or query from a drop down list
in the forms control source. Then you can add text boxes
and select which fields you want displayed using the
fields control source in the same manner.
 
Thanks

Believe it or not, I found this out about a minute after I sent the question

John H W
 
Try creating the form using the "Form Wizard". it will ask you to select a
table or
query on which you want to base the for.
---Phil Szlyk


Alan Fisher said:
-----Original Message-----
Needless to say, I am new to Access, although I had years programming DOS databases.

In a form I want to display data that is in a table. In
Click to expand...
the form's Control Source I put (without quotes) "=
[Clients]![IntroDate]" - where "Clients" is the name of
the table and "IntroDate" is the field in the table. I
get #NAME error.
The above is what Access put in.

Thanks,

John H W
.
You have to select a table or query as the forms control
Click to expand...
source, then add text boxes which reference fields from
the table or query. In the forms propery page you should
be able to select a table or query from a drop down list
in the forms control source. Then you can add text boxes
and select which fields you want displayed using the
fields control source in the same manner.
Click to expand...
 
Back
Top