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?
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 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...
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...