By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Using VBA to update current record and not the first record

P: 3
Hi all,

I'm new to all of this and this is probably straight forward. I have a form which is basically to be used like a checklist for a set of business processes in processing an application form that is received by the business. (The database is used to record the information from the application form and monitor stages to the application process.)

The 'checklist' is also used as a trigger point. That is, when certain items are flagged as complete, the 'status' changes automatically to let the user know that stage is complete.

I have tried putting a line of code under the "On Change" event of a combo box...

If Me.AppStatusID = 0 Then
Me.AppStatusID = 1

and that works fine for the first record. When I add a new record using the combo box, the AppStatusID always goes back and always changes the first record entry and not the current line item. Could you please help? Presumably something needs to tell it to use the current record line?

Thank you
Aug 18 '08 #1
Share this Question
Share on Google+
1 Reply


P: 3
By the way, it's a MS Access database. Forgot to mention that!

Thanks
Aug 18 '08 #2

Post your reply

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