I started with a dashboard and am now stumped. I need a button/combo box etc hat will edit fields in the "agent" table. The manager wants to be able to "see" the agents names, not type them in.

Here is my database so far. Ignore the "update" queries section..that is my next problem to fix. I have tried a drop down box to find the agent but when I select their name, it brings me back to the "first" record in the agent table so I am missing something somewhere.... Can you please look at my code and let me know.

There doesn't seem to be an attachment?

Sorry...there it is.

Monique, I am working in a lower version of Access so I am not able to make changes to your database.
You need to go to the datasource of the frmAgent and refer to the combo box on the Dashboard in the criteria field.

SELECT tblAgent.AgentID
FROM tblAgent
WHERE (((tblAgent.AgentID)=[Forms]![Dashboard]![Combo17]));

This should work. If not, let us know. I am going into a meeting so I may not be available to help for a while but there are many people here who will.
Good luck!

When I open this I only see the first initial(?) of the name, not the last name. Could be on my end?

Hi

Which Form are you talking about ??

Hi

There will probably be a better way to do this but see attached

Now when you select the Agent using the Combobox you can Click
the Command Button "View Agent"
The agent form will display the Agent selected

Click to view attachment

Thanks Mike, I think that will work just fine. Now onto the queries