467,088 Members | 1,288 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Using VBA to update current record and not the first record

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
  • viewed: 3469
1 Reply
By the way, it's a MS Access database. Forgot to mention that!

Aug 18 '08 #2

Post your reply

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

Similar topics

reply views Thread by Anthony Robinson | last post: by
5 posts views Thread by junglist | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.