Requery Control AFTER Entry Made on Pop-Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form "f_Complaint" that is the main complaint entry form. I then
created a pop-form "f_AddProd" to be able to add new products. Initially I
figured this pop-up would come from the Main form, then decided it would be
neat to have have add products during "f_Complaint" if the product isn't
there.

I added a picture (+ sign) on "f_Complaint" which pops up the "f_ProdAdd"
just fine. Any records added to the this form populate the "t_Prod" table
just fine. I have two buttons on that form that Save and Close respectively.
Save by the way freshes a subform on the "f_ProdAdd" so they can view the
changes.

What I would like as is a soon as they click "Save" on "f_ProdAdd" the
"ProdID" control on "f_Complaint" updates to show the new prod.
 
Never mind, had it backwards

Lori said:
I forgot. I've added the code:
DoCmd.Requery (Forms![f_Complaint].[ProdID])

and get told run-time error 2109, there is no field name 13 oin the current
record.

Lori said:
I have a form "f_Complaint" that is the main complaint entry form. I then
created a pop-form "f_AddProd" to be able to add new products. Initially I
figured this pop-up would come from the Main form, then decided it would be
neat to have have add products during "f_Complaint" if the product isn't
there.

I added a picture (+ sign) on "f_Complaint" which pops up the "f_ProdAdd"
just fine. Any records added to the this form populate the "t_Prod" table
just fine. I have two buttons on that form that Save and Close respectively.
Save by the way freshes a subform on the "f_ProdAdd" so they can view the
changes.

What I would like as is a soon as they click "Save" on "f_ProdAdd" the
"ProdID" control on "f_Complaint" updates to show the new prod.
Click to expand...
Click to expand...
 
Back
Top