michaelpotts
New member
- Local time
- Today, 22:05
- Joined
- Jul 30, 2002
- Messages
- 9
Hello,
I need some help, I have one form which has only one unique key filed on it called 'call_number', it also has about 20 others fields, while this form is open I have a button that leads to another form where I can search for the call_number I want to use, the information I have on this form is in a subform (in datasheet view) which is pulled from a query. What I want to do is when you find the record you want to use, is be able to double click on a field within that record set and it will close the form currently open and display the record selected in the original form.
Please say if I am not clear enough or if I require more information to be posted.
thanks
I need some help, I have one form which has only one unique key filed on it called 'call_number', it also has about 20 others fields, while this form is open I have a button that leads to another form where I can search for the call_number I want to use, the information I have on this form is in a subform (in datasheet view) which is pulled from a query. What I want to do is when you find the record you want to use, is be able to double click on a field within that record set and it will close the form currently open and display the record selected in the original form.
Please say if I am not clear enough or if I require more information to be posted.
thanks