I have created a form used to enter data into a service log for PC repair. Once a pc users Id has been entered how do I use that Id to access a file not associated with my form in order to display information to the service personnel. What I am trying to do is find the users name in the customer file and display it on the service request.
Textboxes
- Thread starter clauses
- Start date
TessB
Plays well with others
- Local time
- Today, 17:21
- Joined
- Jan 14, 2002
- Messages
- 906
May I please have the following information:
Currently, how does this form and service request interact? After completing the form, do you press a button and print a service request?
Is the service request a report? Another form based on a query? What?
What tables.fields are used on the form and the service request?
I ask this because the answer just seems so obvious to me that I must be missing something. Obvious answer being "Base your service request on a query that includes the table housing the PCuserID and Name fields together and add the Name to the service request."
But if I'm missing something, let me know!
Tess
Currently, how does this form and service request interact? After completing the form, do you press a button and print a service request?
Is the service request a report? Another form based on a query? What?
What tables.fields are used on the form and the service request?
I ask this because the answer just seems so obvious to me that I must be missing something. Obvious answer being "Base your service request on a query that includes the table housing the PCuserID and Name fields together and add the Name to the service request."
But if I'm missing something, let me know!
Tess
The user id, call date, service date, and service description are on both the form and the service file. Once a user Id has been entered on the form(after Update) I would like to access the customer file to make sure the computer exist and if it does place the customers name on the service request form.
The form is used to enter and update service request. The data on the form is not based on a querry but is related directly to the service file.
I thought about using your suggestion using a query but I do not want the person entering the request to inadvertently change the customer file, i.e. give them a new name.
The form is used to enter and update service request. The data on the form is not based on a querry but is related directly to the service file.
I thought about using your suggestion using a query but I do not want the person entering the request to inadvertently change the customer file, i.e. give them a new name.
