Add a record from a bound subform to an unbound subform

[jrperez.munloiza]

Ok. This is the situation.

I have a main form (frmMain) with two subforms (sbfrmBound and
sbfrmUnbound).

I move data from sbfrmBound to sbfrmUnbound using this code in a button
on sbfrmBound:

Forms!frmMain!sbfrmUnbound.Form!Field1 = Me.Field1 '("Me" refers to
sbfrmBound)
Forms!frmMain!sbfrmUnbound.Form!Field2 = Me.Field2
Forms!frmMain!sbfrmUnbound.Form!Field3 = Me.Field3
Forms!frmMain!sbfrmUnbound.Form!Field4 = Me.Field4

It works adding data to the first record on sbfrmUnbound. But then I
try to go to a new record, and I can't, either create a new record,
move the focus to sbfrmUnbound, and many many solutions.

I want to:
-Set the focus to sbfrmUnbound
-Add a new record to sbfrmUnbound with data from sbfrmBound

Any help will be aprecciated.

Juan

 

[John Nurick]

Hi Juan,

If sbfrmUnbound is unbound, it's meaningless to talk about "going to a
record" or "creating a new record": all you have is the subform, the
controls on it, and the values they contain.

Otherwise, please give more information about what you are trying to
achieve.