ProgEvalJAA
MIS
My specific question is: What step(s) am I overlooking with the Requery Method that I receive an error?
I have a form with a field labeled "Staff Contact." After a user inputs a new Staff Contact, saves the record and then moves to the next record, I want the requery method to refresh the list of values. That way, if the user has typed in a new Staff Contact name, the list will be updated with that Staff Contact and all previous Staff Contacts. Then, when the user moves to the next record and starts typing the new Staff Contact name, Access will suggest the typing without the form and its subform ever being closed.
To accomplish this on another subform of a different form, I created a combo box called Company Name. Then, I created a query of Company Names and used that as the Row Source for that combo box. Next, I created a macro called Requery Company Names and attached the macro to the After Update Event of the Company Names property box. This works fine and does exactly what I expected it to do in suggest the typing for any new names without the form or subform being closed.
For some reason, when I attempt to replicate this for the staff name on another subform of another form, I receive an error message of 2950 saying there is no such field named Staff Name. I did some research about the error, and according to Microsoft, it means the database is not trusted. However, all the databases I use are on a trusted location. I also verified this using an AutoExec macro, and it indicates the database is trusted as well.
Does anyone have any additional thoughts?
I have a form with a field labeled "Staff Contact." After a user inputs a new Staff Contact, saves the record and then moves to the next record, I want the requery method to refresh the list of values. That way, if the user has typed in a new Staff Contact name, the list will be updated with that Staff Contact and all previous Staff Contacts. Then, when the user moves to the next record and starts typing the new Staff Contact name, Access will suggest the typing without the form and its subform ever being closed.
To accomplish this on another subform of a different form, I created a combo box called Company Name. Then, I created a query of Company Names and used that as the Row Source for that combo box. Next, I created a macro called Requery Company Names and attached the macro to the After Update Event of the Company Names property box. This works fine and does exactly what I expected it to do in suggest the typing for any new names without the form or subform being closed.
For some reason, when I attempt to replicate this for the staff name on another subform of another form, I receive an error message of 2950 saying there is no such field named Staff Name. I did some research about the error, and according to Microsoft, it means the database is not trusted. However, all the databases I use are on a trusted location. I also verified this using an AutoExec macro, and it indicates the database is trusted as well.
Does anyone have any additional thoughts?