Updating problems

[Guest]

I have a problem with when a record updates, and how can I refresh it so it
passes a variable to a new form to create a new record there?

I have a sub-form where I'm entering line item invoice/reimbursement
information.

frmMasterInvoice - Payee, Date, Invoice Amount, Invoice # - all fields
matching to the tblInvoice.

frmLineItem - LineItem#, Invoice# (to link to the master table), Submitted
items, Approved items, Reimbursement Amount - and a button for "Exceptions".

The Line Item subform and the Exception form

When you click on the "Exceptions" button, it launches a new form,
"frmExceptions" -

Exception#,LineItem#, Name, ID#, ExceptionReasonCode

If I'm still inside the "Line Item" subform, entering a new line item, and
click on teh "Exceptions" button, I get an error when attempting to create a
new "exception" record. No "LineItem#" variable is passed from the subform.

If I enter the line item, then click on the "Recalculate" button on the main
form (i.e. leave the Line Item record to attend to updating the Master
Invoice record), then click on the "Exception" button in the subform, it
allows me to enter new exception records on the other form.

*** How can I get that Line Item record to refresh/unlock/whatever in the
subform without leaving it, so it passes the "Line Item" value to the to be
opened form where I enter the new exception record? "Line Item" is the
primary key and is an autonumber form, just as the Invoice# and Exception#
fields are for their tables. ***

Since I'm making this application for others to use, I don't want to have
them have to do something that is not intuitive ("When filling out the line
items, you must refresh the entire invoice before creating the exception
details...." ugh!)

 

[Guest]

Never mind. I thought I had tried this before, but maybe it was in the wrong
place/form...

Anyhow, on the "Line Item" subform, I placed a "Me.Refresh" line on a
control that always gets focus before someone can continue, and that seemed
to do the trick.