Add a record from a bound subform to an unbound subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrperez.munloiza@gmail.com - 28 Oct 2005 14:41 GMT

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

Reply to this Message

John Nurick - 31 Oct 2005 18:18 GMT

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.

>Ok. This is the situation.
>
[quoted text clipped - 21 lines]
>
>Juan

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message