Search results

Thanks Frothingslosh: The lookupfield is actually a list of values that were typed in while designing the table using the lookup wizard. It is not pulling from a table. Will I have the same problem if I use a the list combobox on the form instead?

Thank you madefemere. The code did not work. Is there any other to do this? Thanks for you help.

Help needed: My table fields are as follows: 1. Issued? (This is a lookup field with the following lists "Yes"; "No"; "NA") 2. IssueDate I created a subform bound to the table I wish to accomplish the following on the form: 1. If "No" is selected on the [Issued?] field, I want the...

Thank you very much. That did it. Have a happy holidays.

Thank you very much for the prompt response. I've adjusted the code as you suggested. However, I receive an error message: Compile Error: "Exit Function Not Allowed in Sub or Property" With Exit Function highlighted. When I click OK, it highlights "Private Sub Form_BeforeUpdate(Cancel As...

Re: Executing Multiple Event Procedures in Access 2007 This this the code that I've tried. The first part works perfectly. However, once I add the second part, it stops working. I am still new to this and will appreciate any assistance that anyone can offer. Thanks. Private Sub...

I have a form that is bound to table with the following fields: [DateAssigned] [Due] [StaffA] Lookup field [DateInfoRequested] [DateInfoReceived] [DateInfoAssigned] [DateInfoDue] [StaffB] Lookup field What I want to accomplish is if [DateAssigned] is updated, you must select the assigned...

No. They are typed in. Thanks.

I have a database with about 30 fields. Each field contains five possible choices such as: Correct Policy Incorrect Information Disregarded No Verification Verification Not Required 745 Potential If I reviewed 15 cases from one Case Manager, I want a report that will tell me for EACH FIELD...