By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,685 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,685 IT Pros & Developers. It's quick & easy.

Subform dissapears when adding a new record to main form

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.