"Updateable" query???

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hello,

I am binding my form's record source to a SELECT query to
get the proper fields to show up. All the fields are are
visible in 'design' view, however when I switch to form
view the form is completely blank.

I noticed a similar posting from back in May '03 where the
person who answered suggested that the query needed to
be "updateable".

Can someone please expand on what was meant
by "updateable", or could someone help me understand why
this is happening?

Thank you in advance,

Todd
 
"Updateable" simply means you can add and change records
in the recordset. If your query is not updateable, and
you don't have any records returned by the query, your
form is going to show you a nice, gray, but totally
useless window. And you get paid for that!

There are many reasons a select query may not be
updateable. Post your SQL and I'm confident we can help.

David
 
Back
Top