How 2 avoid manual entry using an Access db?

[Guest]

I am trying to build an Access database that helps my employees avoid having
to manually enter data that is already in applications/programs on the
network when they are trying to submit a request for an item in an order in
that account to be investigated by another department.

Customer Account --> Order/invoice for that account --> item on that
order/invoice

I have built the database to where the employees type an account # into an
Access form text box. Then they hit the button "Create a request to
investigate an item on a specific order in this account". It pulls up all
the orders/invoices associated with that account in a combo box. Then they
select the order they need to be investigated. A list box then displays all
the items requested for that order/invoice. All this information comes from
the Order Table I link into from the network. They double-click the line for
the item they need investigated in the list box and it opens up a new form
that displays all the detail from the linked table tblOrderData that was in
the list box and tons more of the fields. This is where I get stuck on how
to design what I need.......

I want the data from that specific item/line in the list box that comes from
a linked table on the network that pops up on a new form to populate a table
of my own that will contain all "Item investigation requests". I envision my
table as a growing table, one by one, as an employee enters a request for an
item to be investigated. I want it to have the information from the item
line in the list box that they double-clicked that just populated a new form
AND I want it to have some comments they manually type AND the time they
entered the request AND their username.

My dilemma is how to get data from a linked table that populated a form with
a very specific item's information AND manually entered data both into a
table of my own. An update query? If so, how?? I don't understand how to
combine both on a form and then get both into a table. Also, the user will
need to be able to modify some of the fields for that item line if they are
easily seen/known to be wrong by the employee. (that's beyond me how to do)

 

[UpRider]

WF, interesting problem. Obviously the form's fields can't be bound to the
linked table and your table as well.
Here's what I would do.
Put a button on the form that the users click when they are done.
The on_click event would have to determine if this is a new record or
existing record in your table. You could accomplish this with a Dlookup. If
the Dlookup fails, it's not an existing record.
Based on that knowledge, use an INSERT query to either add a new row (using
data from the form) or update an existing row (again using data from the
form). In both cases, just update all the columns in the table row with
corresponding fields from the form.

HTH, UpRider

 

[UpRider]

Correction to earlier post.
An INSERT query will add a new row to a table.
An UPDATE query will modify an existing row in a table.
UpRider