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
 
Top