Not sure completely waht you're asking, but you can set the value when you open the form

DoCmd.OpenForm "[Shop_Inventory]"
Forms![Shop_Inventory]!Textbox=cboPart

If you need to determine which form you're starting on, you could use .IsLoaded or something like this

If Me.Name="MainF" Then
'stuff
Else if Me.Name="OtherF" Then
'Stuff
'etc
End If

I have a few type of Inspection forms. When I am working on a certain part number and then I press the "Shop Inventory" Command button. I would like it to fill the text box in with the correct part number from the inspection form. Right now I just made a bunch of copies of the Shop Inventory form and changed the control source to each text box on the shop inventory form to point to the part number of the form I pressed the command button of.

I hope this makes more sense.

So yea, if you are on any form with the cboPart in it, and you open the shop inventory form from there, this kind of code would set your textbox correctly.

DoCmd.OpenForm "[Shop_Inventory]"
Forms![Shop_Inventory]!Textbox=cboPart

Hi Adam,

Thank you. I did as you suggested and all is working well. I now just have one form to use.

Regards,
Mark