D
dan.cawthorne
Hello All,
Ok So i have a select query, that shows enquirys that are been
created, in particular i have a field called "SentDate" and that have
a creteria as Null, so that Query only shows all the which doesnt have
a sent date assigned. so these enquirys can be printed, after a user
has printer her enquiry letters through a mail merge,
she prompted to run a update query which then updates the sentdate
field whith Date()
Whats happening now though is i have more users creating enquirys and
if some is working through a active enquiry and another user is just
finished, it wipes all enquirys.
So I've decided to create a form that has a list box that shows all
the active enquirys so then the user can double click the enquiry
they've created and that update query will only update the enquiry
they've double cliked on,
so what sort of doubleclick event do i need?
"Qry_CreateEnquiry" Which has the DateSent set to Is Null
"Qry_UpdateMailMergeEnquirys" Puts A Sent Date In the Sent Date Field
which is null In The Above Query
So How do i do what i achieve?
Ok So i have a select query, that shows enquirys that are been
created, in particular i have a field called "SentDate" and that have
a creteria as Null, so that Query only shows all the which doesnt have
a sent date assigned. so these enquirys can be printed, after a user
has printer her enquiry letters through a mail merge,
she prompted to run a update query which then updates the sentdate
field whith Date()
Whats happening now though is i have more users creating enquirys and
if some is working through a active enquiry and another user is just
finished, it wipes all enquirys.
So I've decided to create a form that has a list box that shows all
the active enquirys so then the user can double click the enquiry
they've created and that update query will only update the enquiry
they've double cliked on,
so what sort of doubleclick event do i need?
"Qry_CreateEnquiry" Which has the DateSent set to Is Null
"Qry_UpdateMailMergeEnquirys" Puts A Sent Date In the Sent Date Field
which is null In The Above Query
So How do i do what i achieve?