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

 

[dcb]

Whats the current code behind the Combo Box? Want to work out what you are doing! When you say "main indexed field" is this a autonumber? primary key?

 

[Kryst51]

Make your form then in the "On Open" event of the new form add the following code:

DoCmd.GoToRecord , , acNewRec

Then when you make the button on the main form follow the wizard prompts to open your form, show all records. It will open to add new record.