Find what control is using a data item

  • Thread starter Thread starter MeSteve
  • Start date Start date
M

MeSteve

I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
columns.

I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
names.

How do I determine what is trying to refference the deleted columns?
 
I found the problem, the column was still referenced in the underlying query
that fed the form.
 
Assuming that you haven't custom programmed it yourself, ***anytime*** you
get a popup box asking for a field/parameter it means that a query is
involved. Either the column/field is not available in the recordset(s) that
make up the query or the name of the field has been misspelled.

Congrats to you for sussing it out yourself!
 
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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Validation Rules for a Control on a Form (?) 4
What is the extra field added with a combo or list box 2
Access 2003 View Results From Bound Column 1
Form RecordSet Select based on Combo Box value 3
Excel Comparing two columns 1
Excel A CountIF question... I think 2

Back
Top