I have a problem with a table look-up displayed as a dropdown list in a named browse. When <new record> is selected, it gets stuck on <new
record>.
To hard to explain so I will step through it - please see attached file.
- Open database and select form "price_history_worksheet
- Highlight record in upper browse (primary table: description - browse1)
- press F3 to enter "edit" mode
- highlight last field (catagory)
- select dropdown list arrow
- if existing data is selected, everything works fine
BUT
- scroll to last entry <new record>
- select new record
- entry form appears (catagory_form)
- enter new data and save
- form closes and cursor is back on catagory field
Everything works up to his point but here is where things go bad!
- It would be nice if the browse field would now show thw data entered, but it does not so...
- select dropdown list arrow again
- select desired data
- entry form keeps poping up! No way to escape except cancelling the data change.
- the new data entered is saved to the source table but the destination table never receives the data - stuck on <new record>
I'm sure the problem has to do with passing the newly saved catagory_text data to the buffer data for the description record which is still
in edit mode but I need some help in doing this. Several attempts at refreshing,resynching, etc has not affected the problem.
I have attached my program with junk data from testing.
Thanks for any assistance offered.
record>.
To hard to explain so I will step through it - please see attached file.
- Open database and select form "price_history_worksheet
- Highlight record in upper browse (primary table: description - browse1)
- press F3 to enter "edit" mode
- highlight last field (catagory)
- select dropdown list arrow
- if existing data is selected, everything works fine
BUT
- scroll to last entry <new record>
- select new record
- entry form appears (catagory_form)
- enter new data and save
- form closes and cursor is back on catagory field
Everything works up to his point but here is where things go bad!
- It would be nice if the browse field would now show thw data entered, but it does not so...
- select dropdown list arrow again
- select desired data
- entry form keeps poping up! No way to escape except cancelling the data change.
- the new data entered is saved to the source table but the destination table never receives the data - stuck on <new record>
I'm sure the problem has to do with passing the newly saved catagory_text data to the buffer data for the description record which is still
in edit mode but I need some help in doing this. Several attempts at refreshing,resynching, etc has not affected the problem.
I have attached my program with junk data from testing.
Thanks for any assistance offered.
Comment