Update Quantities from one table to another 1

[rockiwood]

I want to update Quantities from one Table (Issues or Receives) to another Table (Inventory). I am using a seperate Form for each Table.

Thanks in advance for any help

Jerry

 

[rockiwood]

It does not resolve to any value. I must be doing something wrong.

 

[scriverb]

If the .FindFirst and the .setfocus is not working on this form then I suspect you have a textbox that has its control source property set to fldIPartNumber but the actual name of is something like Text21 or something. You are referring in both of the about instances to the name of the text boxes while only the Control Source is set to that name.

That is the only thing that makes sense at this point.

Bob Scriver

 

[rockiwood]

Final Results.

The last code Bob sent me work perfectly. The problem was that there were too many references installed. I'm not sure which ones were the culprit, however there were 6 installed and when i backed off to just 3, everything worked perfectly.

Thanks Bob for your perserverance and patience .


jerry

 

[scriverb]

Thanks for the star and good luck Jerry.

Bob Scriver