How can I update the data listed in the combo box to show the most
in [Form]
|
From: New Girl on 17 May 2010 10:49 I have a Database where tables are linked back to the master data tables. The main entry/edit form has a section (as shown) the new Carer record is entered using a separate form then the detail is called from the main form using a combo box. My problem is that the newly entered Carer data does not appear in the list of carers. F9 does not work, closing and re-opening the main form does not work. When I check the item is listed in the Carer table. My question is how can I update the data listed in the combo box to show the most recent record. I would be really grateful for any help with this. Many thanks.
From: Douglas J. Steele on 17 May 2010 11:51 Forms!NameOfForm!NameOfComboBox.Requery -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "New Girl" <NewGirl(a)discussions.microsoft.com> wrote in message news:6C1EB8A0-B327-48A1-8438-70C1E1057471(a)microsoft.com... >I have a Database where tables are linked back to the master data tables. > The main entry/edit form has a section (as shown) the new Carer record is > entered using a separate form then the detail is called from the main form > using a combo box. > > My problem is that the newly entered Carer data does not appear in the > list > of carers. F9 does not work, closing and re-opening the main form does > not > work. When I check the item is listed in the Carer table. > > My question is how can I update the data listed in the combo box to show > the > most recent record. > > I would be really grateful for any help with this. Many thanks.
|
Pages: 1 Prev: TransText Method Next: How do I populate a subform field with a value from the main form? |