using a combo box in subform instead of navigation buttons

[CHTHOMAS]

Hi,

I have 3 tables

1. Project
2. Category
3. Entry

Table project have project no, Project description and client
Table Category have Faxes, letters, Transmittals
Table Entry have Subject, Addressed to, Date and Remarks

1 project can have many Categories, 1 category can have many entries.

I have set the 1:M relationships. Its working fine. I have created forms with subforms for data entry. Project is the main form with Category and Entry as subforms. Its also working fine.
Now am using Navigation buttons in Category subform to enter corresponding details in Table Entry.
My question is, is it possible to use a combo box in Category subform instead of using Navigation buttons. ie i want to select the category type fax/letter/transmittal from a combo box in Category subfrom and then enter the details in Entry subform. Is it possible? Any ideas or suggestions will be highly appreciated.

Warm and Best Regards,

Charley

 

[hermanlaksko]

I am sorry to say that such a thing is possible ;-)
However it looks like a troublesome thing to use for the end user.
If you do not like the navigation buttons on the button of each form, you could try to make a toolbar with these navigation buttons this would be a lot easyer for the end user and , last but not least, for you to administer ;-)

Herman

 

[CHTHOMAS]

Herman,

Thanks. But a little more please? I want to use the combo box only on 1 subform(Category). I don't mind the navigation buttons for the Main form(Project) and the last subform(Entry). What i intend to do is to use the combo box on the second subform(Category) where the user will select fax/letter/transmittal and then enter the details on the Entry Subform. would you like to have a look at my sample zip db(26kb)?

 

[hermanlaksko]

Sure drop on tek-tips@wfbutik.dk and I will have a look and see what I can do.

Herman