Access macros

[mamig]

After clicking a switchboard item, I want to open a macro to ask for a table field (cost center), then open the input form to the record with that cost center so it can be edited. i was going to link the macro to the switchboard item; however, I can't get the macro correct. I am using access2002 version.

[NTC]

"macro to ask for a table field"

what does that mean?

sounds like you need a pop up form with a combobox to look up a field.....

[MAF4Fam6]

If your form is already built, and it is working properly...then a Macro with an Open Form action is all you would need to open your form.
Using a Macro to open the underlying table first is not necessary since your form is already pulling data from a record source, being a table or query.
If your form is not yet built...suggest creating it using the form wizard and have the wizard pull data from the respecive table by cost center.

-RC