Creating Macro to Set Values & Update Table

[jlclark4]

Hey!

I am new to Access 2010 and I am trying to create a email workflow system which provides the user with the next item to be worked (using a table in access).

When they click a button called "Get Next Item", I want the next item to populate (which is generated by qry_02nextitem) in a field located on my form.

Process:
Click "Get Next Item" (button)
Query qry_02nextitem runs, its set to show 1 value (and is sorted) <--this step may not be necessary unsure how to code in VB
then populate Ticket_ID from qry_02nextitem into Ticket_ID on frmOutput
then Update User_ID in tbl_UpdateTableCur with User_ID from frmOutput

I would prefer the query never pop up to the user.




Any suggestions?

[ranman256]

Have the button click open a form using THAT item.

the button puts the next index in a text box on the button form
the event then opens a form , the form uses a query( the query uses that text box as criteria)
then all the data will populate in the newly opened form.

[jlclark4]

The output form where I want the data to populate is actually linked to a different table.

frmInput - tbl_Input (items are logged that come in and assigned a ticket number)
frmOutput - tbl_Output (Could have a ticket number logged multiple times to record each touch)

tbl_UpdateTableCur - No Duplicates, Ticket ID Status table (only contains a few fields. Ticket ID, the time it was logged into Input, current status, user who has item/worked item, and time up status update)

When the user submits a item in the frmInput, it records data to tbl_Input but also to tbl_UpdateTableCur

I'm not sure what you suggested is what I am looking for. I really do not want another form to pop up. I want them to be able to click get next item and somehow get a ID to populate (And write) to tbl_Output/frmOutput