When create new record, some subform became visible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have 1 main form with many subforms.

When I create a new record, some of my subform disappear. Could anyone tell
me what's the problem.

Thanks for your time.
Cheers
 
Hi

I have 1 main form with many subforms.

When I create a new record, some of my subform disappear. Could anyone tell
me what's the problem.
Click to expand...

Not without knowing more about the form and subform properties, no. What is
the Recordsource of the mainform, and of the subform that is disappearing?
What are the Subform's Master/Child Link Fields? What if any VBA code do you
have?

A form will be blank - not even showing controls - if the Query upon which it
is based returns no records (so you can't see existing data because there is
none) and is also not updateable (so you can't see the blank new record
either). Might that be the case for these subforms?

John W. Vinson [MVP]
 
Hi John

There is one to many relationship between the main form and the subforms
where the recordsource is from a table, and the master/child link by a RefID
as a primary key in the Main Form and a foreign key in the subforms.

Some of the subform display ok but other isn't. It's tend to disappear or
ship to another location on the form. and it's only happy to those subforms
only. I have copy the whole property from the subforms that doesn't move but
it's not working.

The code I use is the setfocus to jump from one subform to another subform.

One thing is that when I create a new record in the main form, some of the
subform disappear but when I click on design view and back to the form view,
it's ok.

I would appreciate your help in this.

Have a nice day.
 
Hi John

There is one to many relationship between the main form and the subforms
Click to expand...

No. There isn't.

Relationships do not exist between Forms. Relationships exist only between
Tables.
where the recordsource is from a table, and the master/child link by a RefID
as a primary key in the Main Form and a foreign key in the subforms.

Some of the subform display ok but other isn't. It's tend to disappear or
ship to another location on the form. and it's only happy to those subforms
only. I have copy the whole property from the subforms that doesn't move but
it's not working.
Click to expand...

Are the Subforms on a Tab Control?
The code I use is the setfocus to jump from one subform to another subform.
Click to expand...

Care to post the code? I can't see it from here.
One thing is that when I create a new record in the main form, some of the
subform disappear but when I click on design view and back to the form view,
it's ok.
Click to expand...

That's bizarre, and I have no idea what might cause it - but then I know next
to nothing about how your form is constructed!

John W. Vinson [MVP]
 
Back
Top