Trouble with a date textbox and button on a form.

  • Thread starter Stephen Russell
  • Start date
S

Stephen Russell

I am trying to mimmic a date/time in a table like another on an existing
form.

I have a column in the db CalledIn and when I reference it on a form. My
field shows a little green triangle in the upper left corner.

I don't do much witn access so any ideas?

TIA
 
P

Pat Hartman\(MVP\)

This is Access' way of telling you that there is a potential problem. If
you hover your mouse over the triangle, you should see a dropdown. Drop it
to see the problem and suggested resolution.
 
S

Stephen Russell

Thanks Pat. I saw it. It says that it's an invalid column.

So I have to guess how the columns are delivered to the form?
 
D

Douglas J Steele

Look at the form's RecordSource property. It should be either a table name,
a query name or actual SQL.

If it's a table, does the field exist in the table?

If it's a query or SQL, is the field been included in the query?
 

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

Top