Create new record for the subform

[FJC]

Hi,
I have a form with a subform -- company (form) / Product (subform). The
purpose of the form is to view a company's record, while also viewing the
company's products.

I would like to create a button that would allow me to be viewing the company
record, and then click the button to add a new product for the company.

This seems like it should be pretty simple but I only have basic VB
understanding. Could someone help me out with the code?

Thanks.

 

[Dirk Goldgar]

Hi,
I have a form with a subform -- company (form) / Product (subform). The
purpose of the form is to view a company's record, while also viewing the
company's products.

I would like to create a button that would allow me to be viewing the
company
record, and then click the button to add a new product for the company.

This seems like it should be pretty simple but I only have basic VB
understanding. Could someone help me out with the code?

Is there some reason you don't want to just click or tab to the "new record"
row on the subform and enter the new product there?

 

[FJC]

Doh. Will that always be associated with the current (displayed) company?

Hi,
I have a form with a subform -- company (form) / Product (subform). The

[quoted text clipped - 7 lines]

This seems like it should be pretty simple but I only have basic VB
understanding. Could someone help me out with the code?

Is there some reason you don't want to just click or tab to the "new record"
row on the subform and enter the new product there?

 

[Dirk Goldgar]

Doh. Will that always be associated with the current (displayed) company?

It will if the Link Master Fields and Link Child Fields properties of the
subform control have been properly set.

 

[FJC]

Thank you. It worked (of, course)

I think I was making it harder than I should have.

 

[John W. Vinson]

Hi,
I have a form with a subform -- company (form) / Product (subform). The
purpose of the form is to view a company's record, while also viewing the
company's products.

I would like to create a button that would allow me to be viewing the company
record, and then click the button to add a new product for the company.

This seems like it should be pretty simple but I only have basic VB
understanding. Could someone help me out with the code?

Thanks.

Ummm... you don't need ANY code at all. Just click the *> new record
navigation button in the subform. If this isn't working please explain more
about your form.