>Jojo,
>Thanks for the earlier code. I am still struggling.
>1)When I open up the free table then I need to set the rowsource for the >combo to the free tables uniqiue reference and narrative.(This is choice I >need to give to the user.
>This is data from the other systems free table.
You can put some code in the INIT Event of your Forms with the Combo Box
table should be opened before calling this code..With thisform
.combo1.rowsource = "Your_table_name.unique_field,narrative"
.combo1.rowsourcetype = 6
Endwith
Hope this one can help...
If you want to put your selected records from the form with the grid into your first form and make that record as the record that appear to your combo box, you need to put some code in the
control that get the focus when returns back to your first form..
With thisform
.combo1.rowsource = ""
.combo1.rowsourcetype = 0
.combo1.additem(cVar1)
.combo1.additem(cvar2)
ENDWITH
After you finish selecting the record from
additem, you must put back the rowsource of your combo box bound to a table somewhere else in your first form.
Note: Put some validation so that it will not additem to your combo box the next time that control got the focus...