Form does not update after event

[pedro]

I created a form to display all fields for a record where i created a combo box to select a record. The problem is that after selecting a record from the combo box all other fileds will display correctly however if i go to another record adn return to the same it does not update all other fields.



Thanks

[RuralGuy]

Are all of the controls on your form bound to fields in the RecordSource of the form?

[pedro]

Yes they are... When I select a record from my ComboBox for the first time it works perfectly. Its just if i go to another record which works fine and when i return to the first one it does not work anymore unless i come out of the form...

[RuralGuy]

Something strange is going on. Can you post your db so we can look at it?

[pedro]

Thanks for that... Attached is my full database. and the problem is with the form frm_View_Restaurants

[RuralGuy]

I don't see a problem. How do you get to another record and then back? Did you do a Compact and Repair?

[pedro]

Thanks... Let me see if I can guide you though my issue.

Open From frm_View_Restaurants
From the Combo Box at the top select AM Amalfi
And it should display all the details for AM Amalfi.
From the combo Box select BG Centraa
And it should display all teh details for BG Centraal
From the Combo Box select again AM Amalfi
And this is where the problem happens. It does not display the details for AM Amalfi but keeps the details for BG Centraal.

I really appreciatte you taking time to look at my issue...

Thanks

[RuralGuy]

I see it now. I'll dig in and get back to you.

[RuralGuy]

The AfterUpdate macro of the cbo starts with Next record and should start with the First record.

[pedro]

Thank you very much RuralGuy... I knew it would be something really stupid like that...

[RuralGuy]

Glad I could help. Are you ready to follow the link in my sig and mark this thread as Solved?