Problem with subform automatically jumping to previous record

[mike_980]

I have a form with a subform and to put it simply, the main form contains a box with a numerical field where the user inputs for example "384". However, if the value is the same as a previous record, the subform automatically jumps to the previous record so when the user changes the subform fields to the values of the new record, the old record is replaced. Is there some setting somewhere to ensure that the subform doesn't fill itself with the previous record?

[mike_980]

I have half fixed this issue by replacing the parent-child relationship with my own code which links the two fields. It works perfectly so long as I fill out the subform first then go back to fill in the "parent" value. My problem is that if I fill out the "parent" control first then move onto the subform, the subform doesn't work. The list of values in the comboboxes appear fine but it doesn't let me select anything as if the subform is disabled somehow. All the settings in properties look in order so I suspect it may be a setfocus issue, anyone have any ideas?

[orange]

You have something backwards by the sound of it.
Form /subform set up typically involves 2 underlying tables that are related 1 to Many.
The MainForm is the 1 side and the subform is the Many side.
A record MUST exist in the Main Form (1 {Parent} table) before you can add a record on the Many/{Child} form.

[mike_980]

Mine is working a little differently, I basically have a form which enables you to do one of two things and the job is selectable using a toggle button (I.e add to store or remove from store) however if the user is removing from the store, it needs to be logged where the stock is going. To make it cleaner I used a subform for this job which appeared only when necessary rather than bringing up another form so there is no relationship between the two tables being updated.

I managed to get it working just now, I was right it was a setfocus issue, all I had to do was set the focus to the subform before I sent the value to the subform control from my main form. Without the set focus, the command would still work just fine but it locked up the whole subform as soon as the focus was taken away from it. Strange issue but it's sorted now at least

[orange]

Glad you have it resolved.