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 "transferred" - 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!NewProjectNo and place it on the master ProjectOpeningForm, 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 :)