Subform dissapears when adding a new record to main form

[Nicolae Fieraru]

Hi All,

I have a form which lists information about customers, and I can also add
new customers.
This form contains a subform which lists all the products a customer bought.
If I browse to existing customers, the subform shows properly the products
they bought. But if I want to add a new customer, the subform doesn't show
anymore. If I fill in the details of the form, and move the cursor to a new
customer, and then I come back to my last customer entered, I can fill in
the subform. However, this procedure doesn't seem to elegant to me. I would
like that after I fill in the last details of the customer, to be able to
move to the product details in the subform.

Any advice appreciated.

Regards,
Nicolae

[Chris Belcher]

Nicolae Fieraru wrote:

Hi All,

I have a form which lists information about customers, and I can also add
new customers.
This form contains a subform which lists all the products a customer bought.
If I browse to existing customers, the subform shows properly the products
they bought. But if I want to add a new customer, the subform doesn't show
anymore. If I fill in the details of the form, and move the cursor to a new
customer, and then I come back to my last customer entered, I can fill in
the subform. However, this procedure doesn't seem to elegant to me. I would
like that after I fill in the last details of the customer, to be able to
move to the product details in the subform.

Any advice appreciated.

Regards,
Nicolae

Just a shot in the dark... If the subform is based on a query you may
want to use an event that runs a macro that does a requery. Had a
similar problem with my current project. I'm sure someone will pipe in
with the real answer.

[Nicolae Fieraru]

Dear Chris,

Thank you for your support. I found the reason the subform was hiding.
Somebody who previously worked on the application before was setting the
visible property of the subform to false (in the code) in some conditions...
I commented out those lines and now everything works nice.

Thank you,
Nicolae