G
Guest
Hi. I'm new to Access ADPs and am using Access 2003 to create a SQL Server
2000 database.
I'm using a combo box in Table 1 to look up Table 2. With Table 1 still
open, after adding a record to Table 2, then doing F9 on the combo box, the
added record still doesn't appear in the list. Only when I close down Table
1 and reopen it does the added record in the other table appear in the combo
box list. I've tried F9, SHIFT-F9 and CTRL-F9.
How do I force a requery of a combo box in a table in datasheet view ? Is
there another shortcut key ?
2000 database.
I'm using a combo box in Table 1 to look up Table 2. With Table 1 still
open, after adding a record to Table 2, then doing F9 on the combo box, the
added record still doesn't appear in the list. Only when I close down Table
1 and reopen it does the added record in the other table appear in the combo
box list. I've tried F9, SHIFT-F9 and CTRL-F9.
How do I force a requery of a combo box in a table in datasheet view ? Is
there another shortcut key ?