Hi, I'm trying to use this code

[Watermelon]

Hi,

I'm trying to use this code below to open a form with that where clause criteria but I keep getting a message that the form has closed. Does anyone know why?


DoCmd.OpenForm "PartNumbersSearch", , , "[Part] = " & Forms!PartDescriptionsSearch!txtKeyword & ""

Thanks a lot,
TM

 

[ghubbell]

A little bizarre... try:

DoCmd.OpenForm "PartNumbersSearch", , , "[Part] = '" & Forms!PartDescriptionsSearch!txtKeyword & "'"

Forms!PartDescriptionsSearch is hopefully still open... i.e. the form you are firing this from?
Gord
ghubbell@total.net