-
I am designing a helpdesk system with a VB front on an Access 97 back. In my Call form i want to show call details ( from a call table in access ) and action details ( from the action table in access ).
At the moment I am able to show the call details and action details on the form using two DATA Controls. I have got the first one to prsent data for the calls in text boxes where the second one views the action details for a specific call in a DBGRID. I have been using DAO3.5 to move about the call records and add new ones. I can also show the relevant action details relating to each call.
What i cant do is add to the action details once a new call is opened. Any ideas of how to achieve this would be appreciated.
-
Try re-querying the action dbgrid before trying to add a new action. If the dbgrid is bound by a column that is required from the first table it might not work untill it has been re-updated.
Show some code if this doesn't help.
Hope this Helps
Ian
