Search results

Hi All, I'm having this problem... hope you can help. Or perhaps this is a known issue with Access (2002). The problems is with 2 comboboxes on a form that I have. The first combobox gets it's values from a table and presents it to me in the dropdown list. Simple enough and this works. The...

Hi All, I have a form in which I am having some trouble achieving my goal of auto populating a date field based on a condition determined by a different field. The condition is stored in a field called 'status' and one of the status' is 'Closed'. If someone selects close I would like the...

Thanks! Hi Jack, Yup, that did it. I also added: Me.SubformControlName.Form.AllowAdditions = True so I could add as well as edit records in the subform. Thanks again.

Almost got it! Thanks Pat and Jack for your responses. That did the trick except for one minor side effect... The config you mentioned also locked my subform, which is fine but the button I created to unlock the form does not unlock the subform so I am unable to insert records into my subform...

Hi, I have a form that contains information that once entered, would not likely need to be edited. I would like to have a checkbox to enable/disable edits to the form to prevent accidental editing by, say, novice users. I got the record to lock by adding the following code to a) the after...