new record with combo box?

[razoRjaw]

can anyone point me in the right direction?



I have a form with a combo box to choose the main indexed field. it auto populates the rest of the fields when you select one choice.

if I press "new record" it blanks all the txt boxes (good) but I can't type a new entry in the main combo box (bc its not part of the list)

I'm thinking I need to make a button that says "add" and it brings up a dialog form with a txt box instead to add the new entry in the main record, then once the new indexed entry is there it can bring up the form with all the other fields and let you enter the info for them also.

am I thinking about this right?

and how can I make a txt box that brings up the new record only?
any help is appreciated

[SoftwareMatters]

What you are talking abut seems a bit convoluted to me. Is the main index an autonumber? If so then you should just add the data to the new record then do a requery on the combobox to display it - this is assuming the combobox shows all records in the table.