This is really basic but I'd appreciate some help.
I have a table called tblDetails that has a field called QorA, which holds either the letter Q or the letter A (big surprise, eh?).
The field defaults to Q as per the table setup.
Whenever data is entered into that table using a certain form, I want the value entered into QorA to be the letter A, but I don't want to show this field on the form.
I was planning on using the AfterUpdate event for the form to have code set the value.
What is the proper code to do this?
tblDetails.QorA ="A" didn't work
Is there a good online reference for VBA???
Thanks.........Dan
I have a table called tblDetails that has a field called QorA, which holds either the letter Q or the letter A (big surprise, eh?).
The field defaults to Q as per the table setup.
Whenever data is entered into that table using a certain form, I want the value entered into QorA to be the letter A, but I don't want to show this field on the form.
I was planning on using the AfterUpdate event for the form to have code set the value.
What is the proper code to do this?
tblDetails.QorA ="A" didn't work
Is there a good online reference for VBA???
Thanks.........Dan