How to reference a Access table

[dillon]

Hello,
I am quite new to Access although I have done a bit of coding with Visual Basic. This may seem like a very silly question but I have done a bit of research and can not seem to find the answer anywhere, it is frustrating me.. How do you actually reference an Access table as opposed to an SQL table like how ALL of the tutorials seem to be on.

For example: I have a table tblPublications with a Boolean column colCheck. How would I make an on click event (with a cmd button not the actual checkbox) to say colCheck = FALSE?

I have Access 2003, if that makes a difference.

 

[bob fitz]

If the form that has the button on it is bound to the table, you could do it with this:
colCheck = FALSE
Me.Dirty = False

but it seem (at least to me) to be a strange request.

 

[dillon]

oh... so you don't need to say anything about what table you are talking about? lol that is probably why I could not find anything on it. Thanks!

Would tis make the whole column false? How do you reference a specific row in the column?

 

[bob fitz]

oh... so you don't need to say anything about what table you are talking about? lol that is probably why I could not find anything on it. Thanks!

Would tis make the whole column false? How do you reference a specific row in the column?

If the form is bound (the form's Record Source proerty is set to a table/query) then Access knows which table(s) it is working with. Each row from the table/query is shown as a record on the form, so Access knows which row of data is being changed and the code tells it which column. I hope this makes some sense to you. I like to think that I'm better actually doing it than explaining it. If not feel free to post back.