ControlSource Not Shown

E

Earl Partridge

Access 2000, Windows XP
Trying to add data to a form, I add a Text Box, attempt to select the
ControlSource (named BirthDate) but that source is not in the list.
I have other date fields (JoinedDate) and it shows as a ControlSource.
I thought perhaps "BirthDate" was a reserved word so I changed it
to something else. It still does not appear as a ControlSource.
 
A

Albert D. Kallal

If you go edit->view->field list, then all the data fields available for the
form can be viewed.

Likely, you have based the form on a query, and that query does not have
those extra fields. So, check the query, or data souce you are suing for the
form.
 
E

Earl Partridge

That's exactly what it was, the field was not included in the query used.
Thanks.
Earl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not all fields get added to table 1
How to stop Access highlight the text in a combo box after an event 1
DDE function works in A2003 but not in A2007 2
How to convert records in expression fields in Forms to a table? 12
SQL statement in form text control 2
Date last filled... 18
Need to split a field in a combo box 7
Combobox control source - DLookup function 3

Top