Master form with Data Entry Subform problem

[NHNeedsHelp]

Hi, about to go nuts - I have a master form with 3 control buttons, user picks 1 for Const. job, 2 for Envir job and 3 for Geo job. Each button opens a subform containing the project number from master form. The subform is basically a data entry form with a couple of pull down selections for the user to choose. The choices made on the subform auto fill a field called "New Project No" - That new number is compiled from the user choices, like J1-07-1-XXX. The last XXX part of the proj number is the next sequential number handed out by an auto number field of a table which contains the info the user has selected on the subform. That part works great- can generate the new number. I do not need to store the new number is the table that generates the next number. What I do need to do, is somehow get that newly compiled number "transferre d" - updated or requeryied somehow back onto the master form in a text field called "New Project Number". I have literally driven myself nuts trying every possible thing ! I'm no expert, but have a working knowledge of Access. What am I doing wrong ? I tried a control button on the subform named "click to Export new Number to Project Opening Form" in the properties I set the "On Click" macro to take value of subform!NewProj ectNo and place it on the master ProjectOpeningF orm, it says form is not open..... I've tried creating a query and doing a requery but I'm lost... ANY help is appreciated ! It's such a simple task, and driving me nuts that I can't get it ! Help :)

[NeoPa]

Wow.
Your question is a little hard to follow, but I think I've got an approximation of what you want. Check out post #5 of Resetting automatic File Number at start of new year and tell me if this would solve your problem. It means doing things a little differently, but is possibly a better fundamental approach than the one you're using.
Your details are likely to be different but the concept should be the same if I understand correctly what you're trying to say.