Problem copying and using a macro from the Northwinds sample db

[Mike Webb]

Using Access 2K2. Experience level: beginner

I copied the Customer Phone List form and macro from the Northwinds sample
database and modified it to use as an email address filter form. It works,
but not cleanly.

When I press an alpha button, the form sorts and displays fine, but the
Office Assistant pops up and I see:
"Microsoft Access: There is no field named 'LastName' in the current
record.' I then press OK and see an Action Failed dialog box:
Macro Name: macroContact_Email_List.Alpha Buttons
Condition: True:[CurrentRecord]>0
Action Name: GoToControl
Arguments: LastName

I've rechecked all I can think of and I see nothing wrong. Any ideas out
there?

TIA,
Mike

 

[Steve Schapel]

Mike,

The first and obvious question is... after your modifications to the
form, does it have a textbox named LastName on it still?

 

[Steve Schapel]

--
Steve Schapel, Microsoft Access MVP

 

[Mike Webb]

Yes, it does.

Mike

 

[Mike Webb]

I've got the original error to go away, but now have another (small) problem
.... I get a "Type Mis-Match" error when I press any of the option group
buttons. I'm at a loss on what to check. My record source is a single
table. I've looked at everything for something to 'jump out at me', but no
luck. Any ideas on what I should be looking for?
(I am getting the filtered results, as I want, but would like to stop this
error from popping up before I deploy the FE to the users.)

TIA,
Mike