Openform wizard results in blank record

[Dougalsworld]

Hi All

I'm currently working on a product catalogue, i have a product data screen (frmProductLookup) one of the field s i have is "Replacement" for when a product is superseeded. What i want to achieve is to be able to click on a button and open a second product data screen that automatically goes to the record for the replacement product.

I've currently tried creating a duplicate data form (frmProductLookup2) and used the openform wizard, but for some reason this pulls up a blank record...any ideas

cheers.

 

[RuralGuy]

You need to use the WhereCondition parameter of the OpenForm:
DoCmd.OpenForm(FormName, View, FilterName, WhereCondition, DataMode, WindowMode, OpenArgs)

ie:
strWhere = "[product] = '" & Me.Product & "'"
DoCmd.OpenForm "frmProductLookup2", , , strWhere

 

[Dougalsworld]

Thanks for the quick reply, sorry mine is so slow (connection problems at home).
I found that the reason my open form wizard wasn't working was because of the mutant way i had designed my form that was being oppenned, this has now been sorted and it works a dream.

Thanks for your help on this, cheers.

 

[RuralGuy]

Glad you got it working and thanks for posting back with your success.