Setting an open file flag

  • Thread starter Thread starter Tim A.
  • Start date Start date
T

Tim A.

I have a form used to enter a request for service. When
viewing the requests for service, the user can enter a
disposition (seperate table linked by the EventID).

What I would like to do is when the user clicks on Save
Request, is to have a disposition of 'Opened'
automatically input into the disposition table.

Any help will be appreciated.

Thank you.
 
I think I found the answer but I am having trouble with
the format. Can someone assist?? Thanks.


INSERT INTO Dispositions([Date, [EventID, [Disposition]]])
VALUES ([=DATE(), [Me.EventID, [Opened]]])
 
Back
Top