Writing values from a cascaded combo box

[siuesiue]

Hey John,

Got it, I missed the 'Allow Edits' property on the sub form.

I think I am good now, will play with this some more, and if I need any more help I will be asking you again.

I dont know if I can thank you enough for your help, but I did learn quite a bit from you (and still trying to sink it in).

And finally I wanted your opinion on the DB. I was thinking for any new customers or products, I will create an entry form for the same. Is that a good practice, or should I allow the operator the option of adding a customer or new product from the invoice itself. So if the customer is not in the DB then he/she can type it up on the form, or should I create a new form for Customer or Product entry?
Which is a good way or typical way to do it?

 

[John Big Booty]

Hey John,

Got it, I missed the 'Allow Edits' property on the sub form.

I think I am good now, will play with this some more, and if I need any more help I will be asking you again.

.......

Way to go

.....

I dont know if I can thank you enough for your help, but I did learn quite a bit from you (and still trying to sink it in).

.........

Glad to have been able to help.

........

And finally I wanted your opinion on the DB. I was thinking for any new customers or products, I will create an entry form for the same. Is that a good practice, or should I allow the operator the option of adding a customer or new product from the invoice itself. So if the customer is not in the DB then he/she can type it up on the form, or should I create a new form for Customer or Product entry?
Which is a good way or typical way to do it?

Whichever way you go, you will need forms for both those functions. My preference would be to give the user the opportunity to access both those forms from the main menu. I would allow access to them from the data entry forms in the case that the user discovers they need to add a new client or product whilst they are half way through the data entry process.

Most of the DB templates in Access do this through the on Double click event of a combo, so check one of them out and see how they do it. I know the contact management template does it that way.