can not see the addional record

[Frank Situmorang]

Hello,

I have a member data input for based on member table. In this form I have
the address based on the address table, I have a combo to view the member
address.

When I add the new member address trhu the menu, then I go back to the
member imput form, I can not see simultaneously the the addresss that I add
in the combo. I should exit the form then I go back to the intended record
then I click the combo then I can see the just added address.

My question why I can not see direclty as soon as I add already the address.
Is there any way, or in the link of the table I need to use Cascade?
atutomatic add in the foreign key?

Thanks for any help

 

[Tom van Stiphout]

On Fri, 20 Feb 2009 01:56:03 -0800, Frank Situmorang

If I understand you correctly you are adding a record to a table (via
a separate form - let's call it Form2) that is also used as the
rowsource for a dropdown on your primary form (let's call it Form1).
That's by design. Access does not requery the rest of the world when a
row is added to some table, for obvious performance reasons. However
you can write some code to requery the dropdown. For example in Form2
after you add a record (perhaps the Form_AfterUpdate event), you can
write:
Forms!Form1!myCombobox.Requery
(replace myObjectNames with yours)

-Tom.
Microsoft Access MVP

 

[Frank Situmorang]

Thanks Tom, yes it works perfectly. This is good because it could be I have
to open the new address for the member while I am reviewing the member data
and I can update it on the spot.

Again thanks very much