Search results

Well. Thanks a bunch. You have been a great help.

If this is the case, I wouldn't need the field Active in my table. The DateActive field would be populated and the DateReleased field would be empty or visaversa. I could then create further reports from that. Is this a better way? thanks merv

OK. I guess I am trying to do all this from the database Table itself. You are saying I should use a Form with controls? thanks so far...

perhaps I don't read you right but here is what I would like. I will create a new user, enter name, address, phone# and then activate them by a checkbox. At this point I don't have a date entered. If the the activate date was entered automatic if the active field was checked, that would save...

Is there somewhere in access where I can put in code or something to enter the date of that day (in DateActive) field when the active field is checked and enter the date in DateReleased field when the box is unchecked? see below. To better explain. I have a user table and an Active Field...

I have worked with excel a bit but not access. Hope you don't mind some probably simple questions in the next little while. merv:)