Subform not updating from unbound textbox on main form

[philrm]

I have a continuous sub form bound to a single table. I use a unbound text field on the main form to supply a default value thet the user inputs, and will be used in up to 30 records. This works well when you first open the form, but after entering one lot of data, I am unable to update the subform with a new default value and enter the next lot of info. If I close the form and reopen it works again. What do I need to do to enable data entry to continue without closing and reopening the form Eg a button that will take the user back to the unbound text box allow a new default value to be entered and then press enter to go to a new record in the subform. NB the unbound text box is using the setfocus (on the sub form) and (gotorecord new record) after update to step into the sub form and create the first new record, is this a problem? [sig][/sig]

 

[Lightning]

It sounds like your first lot of data is not saving, and is stopping the new record from accepting data.

Before your GoTo New Record command, try adding a Save command (Docmd.Save).

Hope this helps.

Lightning [sig][/sig]

 

[ph2]

Philrm,

Please can you help ?

I am trying to use a value in the main form as a default value in my subform (as I believe you say you have working well). I can not get it to work, please could you give me an idea as to how you achieved it. I have tried many different ways but keep getting errors.