Change content with update query

[sknechte]

I would like to insert values into these rows with an update query, but every time I make an attempt to do so, I return 0 results.


Here is what I have tried

[isladogs]

Enclose the update string in quotes " at the start and end
If it still fails, change the criteria to include empty strings - Is Null Or "'

[CJ_London]

or you can leave as null and use the format property - something like

@;"Requires more information"

benefit is you still have the null as a 'value' to indicate no information so you can still use the nz and isnull functions

I often use it to request the user to enter something e.g.

@;"Enter first name here"
@;"Enter last name here"

if used in the right way can make data entry forms look much cleaner

[sknechte]

I really appreciate both of your replies. I am navigating access blindly, and you two are really helping me out.

[ssanfu]

Just an FYI,
"Description" is a reserved word in Access and shouldn't be used for object names. Plus it is not very descriptive: "Description" of what???
For a list of reserved words in Access, see Problem names and reserved words in Access