May 21 2012, 10:55 AM
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.
May 21 2012, 11:19 AM
There doesn't seem to be an attachment?
May 21 2012, 11:26 AM
Sorry...there it is.
May 21 2012, 11:44 AM
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.
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.
When I open this I only see the first initial(?) of the name, not the last name. Could be on my end?
May 21 2012, 12:01 PM
Which Form are you talking about ??
May 21 2012, 12:18 PM
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 selectedClick to view attachment
May 21 2012, 12:26 PM
Thanks Mike, I think that will work just fine. Now onto the queries
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here