469,579 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Help with Access 2007 Event

I have a data entry form in which there are two synchronized combo boxes - facility and line. Facility is a read only field and the data comes from a global variable which i had set while the user selects their respective facility button on the main form. Based on the facility, line combo box will be displayed (i wrote the code in the "on current" event).
I usually enter 4-5 records and then save them together. Records were saved correctly. Today I entered 4 records and before saving them i had to confirm an entry i made in the 1st record , so i went back to the 1st entry using the back arrow and i noticed the line combo box selection was changing. Because of the oncurrent event, the line combobox is getting populated again.
Please let me know which is the appropriate event to solve this problem (or any property which is similar to IsPostback propertyin .Net)
Feb 19 '10 #1
2 1542
320 100+
I think you guessed your problem. What exactly is your OnCurrent event doing? depending on your answer I'll probably tell you that you should instead be using a one time event to set control properties; events like button clicks and combo box changes. There is also a Form_Load() event
Feb 19 '10 #2
First of all, thanks for your reply. I solved the problem by specifying a query in the row source property of "line" which displays lines based on the facility, instead of writing code in an event and it is working fine. The data is being displayed correctly even when i am looking back at the records before saving them..

Once again thanks for your input.
Feb 28 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Joseph Macari | last post: by
8 posts views Thread by Jeremy Ames | last post: by
8 posts views Thread by elias.farah | last post: by
6 posts views Thread by =?Utf-8?B?SmF5IFBvbmR5?= | last post: by
5 posts views Thread by LadyIlsebet | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.