ControlSource Not Shown

  • Thread starter Thread starter Earl Partridge
  • Start date Start date
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.
 
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.
 
That's exactly what it was, the field was not included in the query used.
Thanks.
Earl
 
You must log in or register to reply here.

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

Setting form Field Properties with code 4
ControlSource form property 2
Not all fields get added to table 1
How to stop Access highlight the text in a combo box after an event 1
What are these? 2
custom currency symbol independent of regional settings 1
DDE function works in A2003 but not in A2007 2
Updating a control's ControlSource clears the form 1

Back
Top