Logical Field ?

M

Mike J

In VBA I am trying to set a YES/NO fiel to Yes or true.

rstMyTable!Field = True doesn't work.

How do I set it to true?

Mike
 
V

Van T. Dinh

I assume "Field" means the Field Name of the Field you want to set the value
for the current Record of the Recordset.

* Have you checked and make sure the Recordset is updateable?

* Do you have rstMyTable.Update after the posted statement?
 

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

Word macro that can call cells out of Excel for a find and replace 0
Making a macro only work on certain files 2
Loop through pages and insert header image 0
VBA word change keys 0
Macro to Select text from a point given to a specific word 2
Select Text to End of Footnote 9
Some mail merge fields not pulling into document 2
ASK Field Formatting 1

Top