docmd problems

[mysteron75]

I am trying to add a search function to a company datbase. Each company as a company number as a unique identifier. The problem I am having is when I double click a search result it asks me for the comapny number. If I dont enter anything and just click ok it takes me to the correct record. How do i stop it from asking for the company number?

Private sub 1sttitles_dblclick(cancel as integer)
 
Dim intx as string
dim intselecteddocument as string
 
intx= me.1sttitles.listindex
intselecteddocument=me.1sttitles.itemdata(intx)
 
docmd.openform "company_record",,, "[tbl_company_number]"& "'" & intselecteddocument & "'"
 
docmd.close acform, "frmsearch"
 
end sub

[TheSmileyCoder]

I dont think its the code you have presented here thats asking for the company number. It its either in the open or load event of the "company_record" form or in its underlying query. You will have to look there.

[mysteron75]

It was in the query. Many thanks

[TheSmileyCoder]

Your welcome. :)