To recap what I am trying to do and what you suggested
I want a drop down list of orders for a site. Data is in a table. You suggest using Rowsource = 3 (SQL select to a cursor) instead of 5 (SQL select to an array). To be sure I understand what I am doing.
1. Can I do the SQL select and in the init method of the form since it invoves 2 tables, 2 wheres and several fields and it is easier to see what I am coding? If so is the Rowsource the name of the cursor?
2. Where do I put the requery command? In the method that does the save, i.e do I use something like
Thisform.comboname.requery()
3. Are there an performance penalties I should be aware off?
4. First time this is used there is no data. What is a good way to handle this situation,
i.e. check if _tally is zero and insert a blank line into the cursor or is there a better way? In this case what is a good method to not seek for a value and then get last record in table?
Thansk for your help so far.