mattloflin
Question Askin Lad
- Local time
- Today, 11:29
- Joined
- Dec 22, 2007
- Messages
- 31
Hey guys,
I have a form (frmSearch) that has a subform (frmDatabase) and the subform lists all my records. Now frmSearch has about 13 criteria that you can search on. That limits down the Records. What I want to do is be able to Double click a single record and it automatically limit the records down to that one.
I was thinking that all I have to do is take the information and paste it in the search fields.
For example say I double click a Record with the Part# = 1 and Rev # = 3 and Serial = 1234 Just copy that information into the Part Rev and Serial search fields and program the click search.
But how would I program the double click as well as the taking the information from that record?
I have a form (frmSearch) that has a subform (frmDatabase) and the subform lists all my records. Now frmSearch has about 13 criteria that you can search on. That limits down the Records. What I want to do is be able to Double click a single record and it automatically limit the records down to that one.
I was thinking that all I have to do is take the information and paste it in the search fields.
For example say I double click a Record with the Part# = 1 and Rev # = 3 and Serial = 1234 Just copy that information into the Part Rev and Serial search fields and program the click search.
But how would I program the double click as well as the taking the information from that record?
