I have several tables, when I want to check if a record exists in a particular table before making any updates or additions, I select an item from table 1 with a combo box, (combo 1), then select the item from table 2 with (combo 2) that matches from combo1 and so on. These combo boxes are not bound, they are to find records. For the ease of updating and using less controls, when I want to update a table, I copy the KeyField from the previous combo box (which is unbound) to another combo box on the form, call this a dummy combo box, I use this combo box as with a text box I can not make a null for requery as data must be present. This combo box is bound to the KeyField from the previous table, this then allows me to use a drop list bound for this table from a combo box or type the data in the combo box if it does not exist, then update the table from the form I am working with. This is all done with Visual Basic. Everything works OK, however, is there an easier way to do this in Visual Basic as I do not like the idea of using a dummy combo box. I would appreciate any advice.
Kevsim
Kevsim