Cascading combobox as my source

[Ravenray]

Ok, guys/gals. Here's the situation. I got my cascading combobox working out great. Now how do I use those values in vb to add new records?

I.E.:

First combobox is the location selection.

Second combobox is the fiscal year selection.

After that, I want to add new records to that fiscal year.

I got my add-record button, but I'm a bit lost of what to do from there.

 

[dcx693]

Why not make the form a bound form (meaning that you set a table or query to be the recordsource for the form, in other words: the form will display records from that table or query). The two combo boxes (and your other fields) can then be bound directly to fields within that table/query. No code (or at least, minimal coding) required.

 

[Ravenray]

Well, here's the situation. I have to combo boxes and one list box. Once the two combo boxes filter what I need, the combo boxes bring up a list of tickets. What I like to do is add additional tickets to that fiscal year. I have it setup that I can view/edit a specific ticket with a double click. Now I just need a way to add more tickets to that fiscal year. The form is bound to the specific table.

 

[dcx693]

You could use some code to add a new record, but you might want to investigate using 2 subforms. For example, when you pick two values from your combo boxes, the first subform would have the listbox with the tickets. As you click on the listbox with the tickets, you would see the details show up in the 2nd subform. You could also enter new records into the subform. Once a new record is entered there, you can requery the listbox in the first subform to reflect the new record.