Using docomd.findrecord in a listbox

C

Colin

hi all,

I have setup a search function linked to a button on a
data input form as below;

Function SearchDocket()
On Error Resume Next
Forms![DocketSearch]![Docket Number].SetFocus
DoCmd.FindRecord InputBox$("Enter Docket Number", "Docket
Query"), A_ANYWHERE, False, A_DOWN, False, A_CURRENT, True
End Function

This works fine, I have also setup a popup form with a
list box where the user can double click on an item in the
list which then launches a form in datasheet view with a
list of the matches.

My question is how do I marry the two. I've tried putting
a button on my popup form which calls the funtion
(correctly modified with the correct filed/form name) but
when I type something into the inputbox nothing happens.

Anyhelp greatly appreciated.

Regards,

Colin.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using docmd.findrecord in a list box 0
Creating a Search using a combo box and then creating a report. 4
Select a Customer from ListBox???? in different Forms 7
Using Styles In An Outline 0
Clearing Fields in a Word Form 5
Run a macro in a report to repeat retrieving info from form 0
Using DoCmd.FindRecord 2
Loop thru form controls that match records in listbox 8

Top