Helpdesk System

[icemanmt78]

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.

[Ianpbaker]

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