Lookup Combo box Problem

[Ali Edwards]

I have a form called 'Address Lookup' consisting of a combo box called 'lookup' in the form header and a text box called 'Address' in the form detail. The record source for the form is qry 'address lookup query' and so is the row source for the combo box.

On the After Update for the combo box I have the following code:

Docmd.ApplyFilter , "[Address]=[Forms]![Address Lookup]![Lookup]"

When I open the form and select a name in the 'Lookup' combo the 'Address' field shows the corresponding address details exacly as planned. However, if I then choose another name in the lookup combo the Address doesn't change.

What am I doing wrong?


Thanks

Alistair

 

[ColinEssex]

If you recreate the ComboBox using the wizard, select the 3rd option "Find record on my form based on........etc etc" you'll get the code done for you.

Basically you need to bookmark it.

Me.recordsetclone.FindFirst "[ID_No] = " & Me![Combo857]
Me.Bookmark = Me.recordsetclone.Bookmark

Col

 

[Ali Edwards]

BerLIMEY!!! That was quick!

Worked a treat and after three days of head scratching really kicking myself for not posting sooner....

Cheers Colin!

 

[sdonovan]

What if when using the wizard you don't have a third option. I am using Access 2000.

 

[Les]

give it a minute. third option is a tad slow