Openning a form in add mode

[Dougalsworld]

Hi All,


This is such a newbie question I realise, but I have a form (frmFOBEntry) with a combobox (cboMarketCode) which returns a list from tblMarketCode.

New records are added to tblMarketCode using a form frmMarketCode

When I look through the combobox on the first form if the MarketCode I want is not there I want to be able to click a button which will open frmMarketCode in add mode.

Have looked through the forum and found all manner of flash ways to open on to certain records and the like, but nothing that simply opens the form so you can add a new record.

Also, if I add a record will the combobox update automatically?

Many thanks

 

[Oldsoftboss]

I use a double click event on the combobox to open a form with subform, The subform is based on the data in the table that feeds the combo box. Once added, you need to refresh the data in the combo box.

Search for the "IsLoaded" function here.

Dave

 

[Oldsoftboss]

Pretty basic, but hopefully you get the idea.