Wow...Out of curiosity, I just removed the () from "Me.txtTimeChanged = Time()" and it worked without error.
Sigh....I should have known it was something silly. Thank you everyone for thinking about it!
They're definitely bound. I can enter data into them via the actual table in DataSheet view and it will display on the form.
I too thought the Before Update event should work fine. I just don't know why I'm getting the error...
In Access 2010, when trying to assign a textbox a value using VBA code I'm presented with this error:
What I'm trying to do is record the date and time whenever a record is modified. I'm using the "Before Update" event to run the following code:
Private Sub Form_BeforeUpdate(Cancel As Integer)...
Myself and one other are basically the only future users.
EDIT:
I was confusing tab control with tab ORDER. I'll look into tab control and see if I can figure out how it would help me here.
EDIT 2: Looked up tab control, no, that's not an option sadly.
Well, the idea was if I TYPED the name in, it would modify the record. If I select the location from the list, it would filter the records. I know it's bad design, I'm just trying to cram stuff in a small space.
Thanks for thinking it over though!
Hello all! I'm sort of bad with Access and I've run across an issue I can't seem to find any information on. Some background:
Right now I have a form where I can view records of computers. I have two combo boxes on this form; one to select the location of the computer and the second to choose...