Create form with category and sub category field.

[hell bomb]

I am trying to create a form that I can use to create new categories and sub-categories of equipment. I have been struggling with this form for about 2 days now, could I get some assistance? Not asking for someone to do it for me, just point me in the right direction or let me know what is the correct way to do this.

I the following tables with the following categories

tblEquipmentType_Main


- EquipmentTypeID
- EquipmentTypeName

tblEquipmentType_Sub
- EquipmentSubTypeID
- EquipmentTypeID
- EquipmentSubTypeName

tblEquipmentType_Join
- JoinID
- EquipmentTypeID
- EquipmentDescription

I am trying to have a single form to create equipment types and sub-types but can't seem to fit all the pieces together properly to get it working.

[June7]

You want to create records in Join that associate records from Main with records from Sub?

Options:

1. single form bound to Join with two comboboxes, one for selecting record from Main and one for selecting record from Sub

2. form bound to Main and a subform bound to Join with combobox to select record from Sub

2. form bound to Sub and a subform bound to Join with combobox to select record from Main

Of course, records must already exist in Main and Sub. Adding them 'on-the-fly' while creating records in Join will require code in combobox NotInList event.

[hell bomb]

I am trying to use this one form to add create categories and sub categories stored in their respective tables. The sub-type field should be optional. Can I get a little more detail how to accomplish this?

[orange]

see this for some additional info

[hell bomb]

@orange

Actually I have watch that video before not its not exactly what I am looking to accomplish.

[June7]

A BOUND form can enter record for only one table. What is it you do not understand about the options I listed? The only other approach is UNBOUND form and VBA code to write records to tables.