By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,210 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

setting control source of a Textfield

100+
P: 553
If i have created a Form.

After creating it, now i create a textfield on it.

How can i set this textfield's control source ?
Jul 25 '07 #1
Share this Question
Share on Google+
10 Replies


Stang02GT
Expert 100+
P: 1,208
If i have created a Form.

After creating it, now i create a textfield on it.

How can i set this textfield's control source ?

Hello,

If you would like to set the control source of your text feild you can do that by

1. RIght click on the textfeild
2. Select Properties
3.Click the "Data" tab ( should be the second tab )
4. Click in the "Record Source" box and a drop down arrow should appear giving you a list of tables and queries to pick from


Hopefully this helps...if not just let me know

Have a good one!
Jul 25 '07 #2

100+
P: 553
Hi Stang02GT

When i click on Record Source, i dont see any fields or anything.
I think by the method you are telling me, you will only see fields if you had bounded the field while creating the form using the wizard?


Hello,

If you would like to set the control source of your text feild you can do that by

1. RIght click on the textfeild
2. Select Properties
3.Click the "Data" tab ( should be the second tab )
4. Click in the "Record Source" box and a drop down arrow should appear giving you a list of tables and queries to pick from


Hopefully this helps...if not just let me know

Have a good one!
Jul 25 '07 #3

Stang02GT
Expert 100+
P: 1,208
Ok, if the drop down give you nothing to select try this

Do the same thing click on the data tab and the control source box

This time at the end of the control source click on the (...)

this will open the Expression Builder, it should be a box that pops up with four boxs, three of which have things in the and one (the top box) is empty.

In the 1st box on the left you should she folders that say (tables, queries, forms, etc.)

if for example you want this textfield to be linked to a table, double click on the tables folder and it opens a tree with all your tables,

then make your selection of what table(or query) the field you want to link your textfield is in, then in the middle box you will see choices of the feilds in your table(or query) that you can select to link your textfield too.

Double click the field you want and it will put it in the top blank box, then hit ok and you should be good to go.
Jul 25 '07 #4

100+
P: 553
Stang02GT,

I have done exactly how you have explained. But this doesn't work.

when checked back my textfield, it just shows the table name all the time ? it is now fetching value from the table's field at all

Ok, if the drop down give you nothing to select try this

Do the same thing click on the data tab and the control source box

This time at the end of the control source click on the (...)

this will open the Expression Builder, it should be a box that pops up with four boxs, three of which have things in the and one (the top box) is empty.

In the 1st box on the left you should she folders that say (tables, queries, forms, etc.)

if for example you want this textfield to be linked to a table, double click on the tables folder and it opens a tree with all your tables,

then make your selection of what table(or query) the field you want to link your textfield is in, then in the middle box you will see choices of the feilds in your table(or query) that you can select to link your textfield too.

Double click the field you want and it will put it in the top blank box, then hit ok and you should be good to go.
Jul 25 '07 #5

Stang02GT
Expert 100+
P: 1,208
hmmm.... let me play around with this for a bit

i apologize for the failed attempts :(
Jul 25 '07 #6

missinglinq
Expert 2.5K+
P: 3,532
A Textbox, which is a Control, doesn't have a Record Source! Forms have Record Sources. Controls have Control Sources!

After selecting the control Goto Properties - Data - Control Source and click on the arrow. A list of all the fields that are bound to the form will appear. Click on the one you want.
Jul 25 '07 #7

100+
P: 553
Missinglinq

thats the point - you've missed that .

If you have a form which has no fields bound to it ......Now you wish to create a Textfield and then set its Control Source to a field in a table -How would you do that ?


A Textbox, which is a Control, doesn't have a Record Source! Forms have Record Sources. Controls have Control Sources!

After selecting the control Goto Properties - Data - Control Source and click on the arrow. A list of all the fields that are bound to the form will appear. Click on the one you want.
Jul 25 '07 #8

100+
P: 553
Hi.

i have learnt how to do it now.
If no table was bound to a form. We can bound it later by:

1- In Design mode, selecting the Form
2- Properties -> Data
3- Choose Record Source

Now if i create a new Textfield, i can set a control source for it.

was a little thing .... took me so long to learn :)

Missinglinq

thats the point - you've missed that .

If you have a form which has no fields bound to it ......Now you wish to create a Textfield and then set its Control Source to a field in a table -How would you do that ?
Jul 25 '07 #9

missinglinq
Expert 2.5K+
P: 3,532
If you have a form which has no fields bound to it
You should have stated that in your original post!
Jul 25 '07 #10

Stang02GT
Expert 100+
P: 1,208
I think thats were i was getting confused,

oh well atleast you figured it out
Jul 25 '07 #11

Post your reply

Sign in to post your reply or Sign up for a free account.